SQL*Plus Enhancements in Oracle Database 10g(一)

在本地伺服器用作業系統驗證登入時10g 支援 sqlplus / as sysdba

9i 下不支援sqlplus / as sysdba  只支援 sqlplus '/ as sysdba'  sqlplus "/ as sysdba"

sv-dev-oracle-01*82*ora9i-/home/oracle>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
sv-dev-oracle-01*82*ora9i-/home/oracle>sqlplus '/as sysdba'

SQL*Plus: Release 9.2.0.4.0 - Production on Wed Jul 9 11:28:59 2008

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

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

SQL> exit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
sv-dev-oracle-01*82*ora9i-/home/oracle>sqlplus "/as sysdba"

SQL*Plus: Release 9.2.0.4.0 - Production on Wed Jul 9 11:29:07 2008

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

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

10g 下支援sqlplus / as sysdba . sqlplus ' /as sysdba' .  sqlplus "/ as sysdba":

[oracle@localhost ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Wed Jul 9 04:59:37 2008

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

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

SQL>