set command

SQL*Plus parameters are set with the SQL*Plus set command. Session parameters are set with an alter session set ... command.

set pagesize 50000alter session set nls_date_format = 'mm/dd/yyyy hh24:mi:ss' nls_timestamp_format = 'mm/dd/yyyy hh24:mi:ss.ff6';

For SQL*Plus scripts

How to log commands and SQL and their output to a file.

set echo onspool logfile[.lst]...spool off

Next: Page 2
Back Up: SQL*Plus