tom kyte login.sql[@more@]define _editor=vi
set serveroutput on size 1000000
set trimspool on
set long 5000
set linesize 100
set pagesize 9999
col plan_plus_exp for a80
col gloabl_name new_value gname
set termout off
define gname=idle
col 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 serveroutput on size 1000000
set trimspool on
set long 5000
set linesize 100
set pagesize 9999
col plan_plus_exp for a80
col gloabl_name new_value gname
set termout off
define gname=idle
col 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
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/309902/viewspace-1057487/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
aix 开启 ssh
下一篇：
oracle 备份
请登录后发表评论
登录
全部评论
