Thoms Kyte 的 SQLPLUS 环境自定义

vi $ORACLE_HOME/sqlplus/admin/glogin.sql

define_editor=vi

set serveroutput on size 100000
set trimspool on
set long 5000
set linesize 200
set pagesize 9999
column plan_plus_exp format a80
col global_name new_value gname
col member for a40
col name for a40
col file_name for a45
set time on
set timing on
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