oracle格式化

cnhawk386

[color="#000000"]define _editor[color="#0000cc"]=vi
[color="#0000ff"]set serveroutput [color="#0000ff"]on [color="#0000ff"]size 1000000
[color="#0000ff"]set trimspool [color="#0000ff"]on
[color="#0000ff"]set [color="#0000ff"]long 5000
[color="#0000ff"]set linesize 100
[color="#0000ff"]set [color="#ff0000"]pagesize 9999
[color="#000000"]set termout [color="#ff0000"]off
[color="#ff0000"]col NAME_COL_PLUS_SHOW_PARAM [color="#0000ff"]for a36
[color="#ff0000"]col [color="#0000ff"]TYPE [color="#0000ff"]for a20
[color="#ff0000"]col VALUE_COL_PLUS_SHOW_PARAM [color="#0000ff"]for a20
[color="#ff0000"]col plan_plus_exp [color="#ff0000"]format a80
[color="#ff0000"]col global_name new_value gname
[color="#ff0000"]define gname[color="#0000cc"]=idle
[color="#0000ff"]column global_name new_value gname
[color="#0000ff"]select [color="#ff0000"]lower[color="#0000cc"]([color="#0000ff"]user[color="#0000cc"]) [color="#0000cc"]|[color="#0000cc"]| [color="#ff00ff"]'@' [color="#0000cc"]|[color="#0000cc"]| [color="#ff0000"]substr[color="#0000cc"]( global_name[color="#0000cc"], 1[color="#0000cc"], [color="#0000ff"]decode[color="#0000cc"]( dot[color="#0000cc"], 0[color="#0000cc"],
[color="#ff0000"]length[color="#0000cc"](global_name[color="#0000cc"])[color="#0000cc"], dot[color="#0000cc"]-1[color="#0000cc"]) [color="#0000cc"]) global_name
  [color="#0000ff"]from [color="#0000cc"]([color="#0000ff"]select global_name[color="#0000cc"], [color="#ff0000"]instr[color="#0000cc"](global_name[color="#0000cc"],[color="#ff00ff"]'.'[color="#0000cc"]) dot [color="#0000ff"]from global_name [color="#0000cc"])[color="#0000cc"];
[color="#0000ff"]set sqlprompt [color="#ff00ff"]'&gname> '
[color="#0000ff"]set termout [color="#0000ff"]on
sqlplus 使用col命令[color="#ff0000"]格式化
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
               
               
               

本文来自ChinaUnix博客，如果查看原文请点：http://blog.chinaunix.net/u1/44757/showart_465516.html