March 24th, 2011 by TheBonsai
SQL*Plus connect strings/logon strings have a couple of special characters, notably these two:
- / (slash) to separate username and password
- @ (at) to separate the TNS descriptor string
If you need to use those characters literally in the logon string, you need to tag them with literal double quotes (literal means: the quotes need to be passed to SQL*Plus, I’m not talking about the UNIX shell):
- Less readable:
$ sqlplus USER/\"PASS/WORD\"
- More readable:
$ sqlplus USER/'"PASS/WORD"'
This entry was posted on Thursday, March 24th, 2011 at 11:12 and is filed under english, Oracle. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.