Oracle SQL*Plus

`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 50000
         

         alter 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 on
         

         spool logfile[.lst]
         

         ...
         

         spool off

Next: Support

Home > Computers > Databases > Oracle > SQL*Plus > Set

Viewing mobile website page. Switch to WML or Full HTML

Oracle SQL*Plus

set command

For SQL*Plus scripts

`set` command