oracle glogin.sql sql> _user,oracle sqlplus常用命令

以为内容选自Oracle官方文档：

----------------------------------------------------------------------------------------------------

1、glogin.sql常用脚本(配置sqlplus command line)

-- To change the SQL*Plus prompt to display the current user,

-- connection identifier and current time.

-- First set the database date format to show the time.

ALTER SESSION SET nls_date_format = 'YYYY-MM-DD HH:MI:SS';

-- SET the SQLPROMPT to include the _USER, _CONNECT_IDENTIFIER

-- and _DATE variables.

SET SQLPROMPT "_USER'@'_CONNECT_IDENTIFIER> "

-- To set the number of lines to display in a report page to 24.

SET PAGESIZE 24

-- To set the number of characters to display on each report line to 78.

SET LINESIZE 78

-- To set the number format used in a report to $99,999.

SET NUMFORMAT $99,999

2、常用命令：

--host                                      sql会话模式利用host命令调用cmd命令

--show                           显示变量货参数值

--describle/desc    描述表结构内容

--SET 命令集：

--SET PAGESIZE 60                    设置一页显示行数

--

--store and restore

e.g.

{

SCOTT@orcl> store set c:\plusenv.sql --存储当前session set 变量值

已创建 file c:\plusenv.sql

SCOTT@orcl> show pagesize

pagesize 24

SCOTT@orcl> set pagesize 60

SCOTT@orcl> show pagesize

pagesize 60

SCOTT@orcl> start c:\plusenv.sql

SCOTT@orcl> show pagesize

pagesize 24

SCOTT@orcl>

}

To be continue...

---------------------------

Dylan Presents.