Common set commands in oracle

The set commands commonly used in oracle are available only in the command line. windows key + R: Open the row. On www.2cto.com -- set the number of characters displayed in each row SQL> set linesize 4000; -- set the number of lines displayed on each page. Setting 0 indicates no branch. SQL> set pagesize 0; -- open the execution plan and statistical information, so that you can view the execution plan SQL> set autotrace on at any time when executing the SQL statement; usage: set autot [RACE] {OFF | ON | TRACE [ONLY]} [EXP [LAIN] [STAT [ISTICS] explain: ONLY show execution plan statistics: show statistics only -- display the execution time of the statement SQL> set timing on;