脚本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
1.将login.sql放入一个文件夹下,并将SQLPATH环境变量指向该目录。
2.在regedit中转到HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE中找到SQLPATH文件(我的是在HOME),双击它并设置路径为存储该脚本的目录。
最后运行SQL*PLUS后结果为
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/21900589/viewspace-622162/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/21900589/viewspace-622162/