|
|
| Re: Difference in connecting as sqlplus / as sysdba, sqlplus "/ as sysdba" and sqlplus '/ [message #380330 is a reply to message #380325] |
Sat, 10 January 2009 22:42   |
 |
ebrian
Messages: 2794
Registered: April 2006
|
Senior Member |
|
|
A quick test would have showed:
E:\>sqlplus / as sysdba
SQL*Plus: Release 10.2.0.3.0 - Production on Sat Jan 10 23:40:08 2009
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
Connected to an idle instance.
SQL> exit
Disconnected
E:\>sqlplus '/ as sysdba'
SQL*Plus: Release 10.2.0.3.0 - Production on Sat Jan 10 23:40:17 2009
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
Enter password:
Connected to an idle instance.
SQL> exit
Disconnected
E:\>sqlplus "/ as sysdba"
SQL*Plus: Release 10.2.0.3.0 - Production on Sat Jan 10 23:40:35 2009
Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
Connected to an idle instance.
SQL> [Updated on: Sat, 10 January 2009 22:43] Report message to a moderator |
|
|
|
|
|
|
|
|
|
| Re: Difference in connecting as sqlplus / as sysdba, sqlplus "/ as sysdba" and sqlplus '/ [message #380401 is a reply to message #380393] |
Sun, 11 January 2009 19:12 |
ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany
|
Senior Member |
|
|
As Michael already said, the all should work the same way, but due to a bug in Windows one of them doesn't work.
| Quote: |
If all are same, then why will we use in several ways??
|
They are not all the same, they should just DO the same. Since different operating systems or scripting languages might require different quoting strategies, you can chose what suits you best.
A lot of times there are different ways of doing things. You can get out of bed right foot first or left foot first. How you do it is up to you. The same applies here.
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
