sqlplus每次进入都进行行宽和页面行数设置
实在纠结
修改文件里的参数如下:
oracle@Sol_ORA:/oracle/12.1/sqlplus/admin$ tail -16 $ORACLE_HOME/sqlplus/admin/glogin.sql
define _editor=vi
set serveroutput on size 1000000
set trimspool on
set long 5000
set linesize 1000
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
第一段设置sqlplus参数
第二段设置sqlplus的命令提示副!