define _editor='D:\Program Files (x86)\IDM Computer Solutions\UltraEdit\Uedit32.exe'
set serveroutput on size 1000000
set num 38
set trimspool on
set long 5000
set linesize 450
set pagesize 9999
set NULL
column plan_plus_exp format a70
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
set time on
set timing on
把这个脚本保存为login.sql, 放在
目录下(如图),也可以设置SQL_PATH变量(好像是这个名字,忘记了),第一行可以修改为自己常用的文本编辑器的程序目录(为ed命令所用)。
其余的不解释了。名字一定要为login.sql。