define _editor=vi
set serveroutput on size 1000000
set trimspool on
set long 5000
set linesize 100
set pagesize 9999
set termout off
col NAME_COL_PLUS_SHOW_PARAM for a36
col TYPE for a20
col VALUE_COL_PLUS_SHOW_PARAM for a20
col plan_plus_exp format a80
col global_name new_value gname
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 '&gname> '
set termout on
sqlplus 使用col命令格式化
col col_name format a20
根据TOM书里面SQLPLUS环境的设置在，/HOME/ORACLE下建个login.sql ,内容：
define_editor=vi
set serveroutput on size 1000000
set trimspool on
set timing on
set long 5000
set linesize 1000
set pagesize 9999
column plan_plus_exp format a80
column global_name new_value gname
set termout off
select lower(user)|| '@ '|| decode (global_name, 'YOUR_SID.REGRESS.RDBMS.DEV.US.ORACLE.COM ', 'YOUR_SID ', 'OR
ACLE ', '10G ',global_name)global_name from global_name;
set sqlprompt '&gname> '
set termout on
set timing on
               
               
               

MegaEntry - Social networking and discussion site!