Listen Software Solutions' "How To" Series: SQL Plus Reports and Commands
By David Nishimoto
SQL Plus Reports and Commands
set headsep - identifies a single character
to split a title onto two or more lines
ttitle - Top Title
btitle - Bottom Title
column - Heading and format of a column
break on - Spaces between the section
compute sum - Calculate subtotals
set linesize - Set the maximum number of characters per line
set pagesize - Set the number of lines per page
set newpage - Set the number of lines between pages
spool - Move screen I/O to file I/O
set pause - Makes screen display stop between pages
save - Save an sql query to file
host - Sends commands to the host operating system
start - Execute sql from a file
edit - Edit sql stored in a file
define_editor - name the editor
Example:
column {field name} heading 'Enter Column Description'
format ann | 9990.99 truncate | word_wrapped
Other Commands
list - Outputs the contents of the SQL Buffer
clear buffer - Removes the contents of the SQL Buffer
append - Add contents the end of the SQL Buffer
c\{search pattern}\{replace pattern} - Changes a search
pattern with a replace pattern for the SQL Buffer.
