Sqlplus common set commands

Sqlplus commonly used set commands set colsep ''; // # -- set echo off, a domain output separator; // # -- display each SQL command in the start script, the default value is on set feedback off; // # -- display the number of records processed by this SQL command. The default value is on set heading off; // # -- output domain title, the default value is on set pagesize 0; // # -- output the number of lines per page. The default value is 24. To avoid paging, you can set the value to 0. Set linesize 80; // ##-- output the number of characters in a row. The default value is 80 www.2cto.com set numwidth 12; // ##-- output the length of the number type domain. The default value is 10 set termout off; /// ## -- display the execution result of the command in the script. The default value is on set timing off; // ## -- display the time consumption of each SQL command. The default value is off set trimout on; /// ## -- remove the trailing space of each standard output line. The default value is off set trimspool on; // ## -- remove the trailing space of each line output by the redirection (spool). The default value is off.