SHOW and SET Commands are two commands for maintaining SQL * Plus system variables SQL> SHOW All - View all 68 system variables SQL> show user - Show current connection User SQL> Show Error - Display Error SQL> Set Heading Off - Disabled Output Title, the default value is on SQL> Set feedback OFF - Disable the counting feedback information of the last line, the default is "6 or more records, back" SQL> set timing ON - Default is OFF, set the query consumption, can be used to estimate the execution time of the SQL statement, test performance SQL> Set SQLPROMPT "SQL>" - Set the default prompt, the default is "SQL>" SQL> SET LINESIZE 1000 - Set the screen display line width, default 100 SQL> set autocmit ON - Set whether it is automatically submitted, the default is OFF SQL> Set Pause ON - Default is OFF, set the pause, make the screen display stop, wait for the Enter key , Then display the next page SQL> SET ARRAYSIZE 1 - default 15 SQL> SET LONG 1000 - Default is 80 Description: long value defaults to 80, setting 1000 is to display more content because many data dictionary views Used a long data type, such as:
SQL> Desc user_views column name can be empty value -------------------------------------- --- View_name not null varchar2 (30) Text_length Number Text Longsql> Define A = '' '20000101 12:01:01' '- Defines local variables, if you want to use a similar in various displays included The constant of the carriage return, - can use the define command to set SQL> SELECT & A from DUAL; original value 1: select & a from dual new value 1: select '20000101 12:01:01' from dual'2000010112: 01: 01 ----------------- 20000101 12:01:01