路径: vi $ORACLE_HOME/sqlplus/admin/glogin.sql
内容:
set timing on set pagesize 1000 set linesize 120 set serveroutput on set trimspool on set long 5000 set sqlprompt "_user '@'_connect_identifier > " column plan_plus_exp format a80 DEFINE _EDITOR = "vim" /* linux */ -- DEFINE _EDITOR = "notepad" /* windows */ col PROPERTY_VALUE for a20 col DESCRIPTION for a40 col event for a30 col P1TEXT for a30 col OPTIONS for a30 col file_name for a45 col tablespace_name for a15 col table_name for a25 col column_name for a25 col member for a45 col status for a10 col segment_name for a25 col SID for 9999999999 col NAME for a50 col DISPLAY_VALUE for a15 col ISSPECIFIED for a12 col UPDATE_COMMENT for a15 COL HIGH_VALUE for a20 col TOPNSQL for a20 col retention for a20 col SNAP_INTERVAL for a20 col DESCRIPTION for a50 col OBJECT_NAME for a30 col parameter for a30 col error for a20 col FILENAME for a45 col value for a35
效果对比,之前如下图
之后如图