--我的 D:\oracle\product\10.2.0\db_1\sqlplus\admin\glogin.sql--glogin.sql 内容 define_editor=Notepad set serveroutput on size 1000000 set trimspool on set long 5000 set linesize 160 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> '; alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss'; alert session set nls_date_language=american; clear buffer; set termout on
D:\oracle\product\10.2.0\db_1\sqlplus\admin\glogin.sql--glogin.sql 内容
define_editor=Notepad
set serveroutput on size 1000000
set trimspool on
set long 5000
set linesize 160
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> ';
alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss';
alert session set nls_date_language=american;
clear buffer;
set termout on