Listen Software's How To: 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.

Running SQL Statements

connect user/password@host

; or / -> to run SQL

@filename -> run the SQL in a file