Important Commands for SQL*Plus Reports

=========================================================

Some Command We have to understand before developing the report by using the command line utility in Oracle database 

=========================================================SET PAGESIZE :– Sets maximum number of line per page and the default value is 24. 

SET LINESIZE :- Sets maximum number of characters allowed per line and the default value is 80. 

SET PAUSE ON/OFF:- Sets system to pause after each page.

TTITLE :- Sets top title for each page of reports. 

BTITLE:- Sets bottom title for each page of reports. 

HEADING :- The HEADING setting controls whether column headings print when you SELECT or PRINT data. The default value for this setting is ON, which allows column headings to print.

COLUMN Command Details:- It is used fo formating of an column in report.

CLEAR COLUMN :- it clear the column command instruction as set previous.

BREAK  ON/OFF :- it tells SQL*Plus where to put spaces between section or where to break for subtotals and totals. it can be turned ON and OFF.

COMPUTE SUM :- it tells SQL*Plus to calculate the subtotals.

SET NEWPAGE :– Sets Number of blank lines per page.

SET HEADSEP :- Heading separator identifies the single character that tell SQL*Plus to split the title onto two morw lines.

SPOOL :- Moves the report into physical file.

SAVE :- save the sql quesry into the file. 

START :- it tells SQL*Plus to execute the instruction from the file.

EDIT :- it invoke a new editor ( Notepad in window)

FEEDBACK ON/OFF :- it disable or enable the display of SQL*Plus Response.