vi $ORACLE_HOME/sqlplus/admin/glogin.sql
#define
SET PAGESIZE 80
SET LINESIZE 170
SET TIMING ON
SET TIME ON
SET VERIFY OFF
SET EDITFILE /tmp/bufferfile.sql
DEFINE _EDITOR=vi
ALTER SESSION SET nls_date_format = 'YY-MM-DD HH:MI:SS';
SET SQLPROMPT _USER'@'_CONNECT_IDENTIFIER'>'
SET FILE_NAME FOR A50
SET TABLESPACE FOR A30
SET NAME FOR A50
SET SEGMENT_NAME FOR A20
SET OBJECT_NAME FOR A20
SET VALUES FOR A50
SET PAGESIZE 80
SET LINESIZE 170
SET TIMING ON
SET TIME ON
SET VERIFY OFF
SET EDITFILE /tmp/bufferfile.sql
DEFINE _EDITOR=vi
ALTER SESSION SET nls_date_format = 'YY-MM-DD HH:MI:SS';
SET SQLPROMPT _USER'@'_CONNECT_IDENTIFIER'>'
SET FILE_NAME FOR A50
SET TABLESPACE FOR A30
SET NAME FOR A50
SET SEGMENT_NAME FOR A20
SET OBJECT_NAME FOR A20
SET VALUES FOR A50
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/18914315/viewspace-741096/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
SQL*PLUS维护系统变量
请登录后发表评论
登录
全部评论
