Basic SQL * Plus reports and commands

Basic SQL * Plus reports and commands 1. remark indicates the behavior comment 2. ttitle: Set the top title of the report www.2cto.com 3. btitle: Set the title at the bottom of the Report. 4. spool imports the on-screen reports to a file. save the SQL statement used to save the buffer to a file: save sqlfile. sqlsave sqlfile. replace SQL rep with save sqlfile. SQL app append list query sqldel of the Current buffer Zone Delete the sqlclear buffer of the buffer zone sqlinput ...... Change ...... Add to SQL Buffer change/pagc/page modify pagc in the buffer to page (usually used in case of incorrect command line SQL input) 6. store to save the current environment settings 7. host sends command 8 to the system during SQL command line. start or @ execute the SQL file that has been saved in the system 9. define_editor sets the default editor in the SQL command line, for example, define_editor = "vi"; then, use edit sqlfile. SQL is like using vi on linux 10. pause settings pause such as set pause 'more... 'The usage is similar to using the more command on linux.