在使用sql*plus时,通常需要对环境进行设置,比如页的大小,行多宽,命令提示符的自定义等。这些都可以通过写一个sql脚本,然后配置SQLPATH环境变量,指向这个sql脚本。重新登录的话,就能将sql里的设置生效了。如:
define _editor=vi
set serveroutput on size 1000000
set trimspool on
set long 5000
set linesize 100
set pagesize 9999
column plan_plus_exp format a80
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 '&gname> '
set termout on