10g Sqlplus工具登陸小改進

前兩天在ITPUB上看到一個帖子，提到如何用最快的方法以SYSDBA登陸資料庫。

 

 

有人給出的方法是sqlplus直接回車，然後在提示使用者名稱時輸入/ as sysdba：

[oracle@yans1 ~]$ sqlplus

SQL*Plus: Release 10.2.0.3.0 - Production on 星期六 8月 8 22:01:47 2009

Copyright (c) 1982, 2006, Oracle.  All Rights Reserved.

Enter user-name: / as sysdba

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

SQL>

其實在10g中，sqlplus做了改進，可以在sqlplus後面直接加上/ as sysdba，而不需要雙引號或單引號：

[oracle@yans1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.3.0 - Production on 星期六 8月 8 22:05:14 2009

Copyright (c) 1982, 2006, Oracle.  All Rights Reserved.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options

SQL>

在9i中，sqlplus還沒有這個功能，必須在/ as sysdba兩邊加上引號。

bash-2.03$ sqlplus / as sysdba
Usage: SQLPLUS [ [] [] [] ]
where ::= -H | -V | [ [-L] [-M ] [-R ] [-S] ]
        ::= [/][@] | / | /NOLOG
        ::= @|[.] [ ...]
        "-H" displays the SQL*Plus version banner and usage syntax
        "-V" displays the SQL*Plus version banner
        "-L" attempts log on just once
        "-M " uses HTML markup options
        "-R " uses restricted mode
        "-S" uses silent mode
bash-2.03$ sqlplus "/ as sysdba"

SQL*Plus: Release 9.2.0.4.0 - Production on 星期六 8月 8 22:25:16 2009

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production

SQL>

從這種小的變化也可以看出，對於Oracle最基礎的sqlplus工具而言，也在不斷的提高易用性。