from [Oracle.9i&10g编程艺术深入数据库体系].(美)凯特
编辑文件login.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
我的电脑》属性》高级》环境变量, 设置此文件的目录,增加环境变量sqlpath