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/[email protected]

; or / -> to run SQL

@filename -> run the SQL in a file

Latest Articles