Set the startup environment variable of SQL * PLUS

Set the SQL * PLUS startup environment variable to d: \ oracle \ product \ 11.1.0 \ db_1 \ sqlplus \ admin \ glogin. SQL (the path of the above file depends on ORACLE_HOME), you need to find the file according to different versions. Www.2cto.com uses the following file to overwrite the content in the above file (which needs to be modified according to the actual situation): [SQL] -- sets the Default Editor used by SQLPLUS, you can select your favorite editor define _ editor = 'C: \ Program Files \ IDM Computer Solutions \ UltraEdit \ Uedit32.exe '-- set the default cache settings of the system output as much as possible to set serveroutput on size 1000000 -- when the text is operated offline, ensure that there is no space in the text line, rather than a fixed width. If you set TRIMSPOOL to OFF (default), the width of the offline files is set by linesize. Set trimspool on www.2cto.com -- set the default number of bytes displayed when long and clob columns are selected set long 5000 -- set the row width displayed in SQL * PLUS to 100 characters set linesize 100 -- set pagesize To a large number Pagesize to control the number of SQL * PUS output headers, each page gets a set of headers. Set pagesize 9999 -- set the default width of the explain plan output. autotrace can be used to receive the explain plan output. The width of a80 is usually enough to accommodate the entire planned column plan_plus_exp format a80 -- this command allows SQL * PLUS to retrieve the latest VALUE OF THE global_name column it receives and place it in the replace variable GNAME. Column global_name new_value gname set termout off define gname = idle column global_name new_value gname select lower (user) | '@' | substr (global_name, 1, decode (dot, 0, length (global_name), dot-1) global_name from (select global_name, instr (global_name ,'. ') dot from global_name ); set sqlprompt 'chenzw> 'set termout on -- enable the SQL Execution time set timing on -- enable the current system time set time on -- enable the returned number information set feedback on -- enable the execution plan information when set autotrace on is followed by sqlplus, detailed execution information is displayed: