TheBonsai's Blog

About the days and nights of TheBonsai

Escaping special characters in SQL*Plus logon strings

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.

1 response about “Escaping special characters in SQL*Plus logon strings”

  1. Ankur said:

    Really helpful. Thanks for the tip. Even my DBAs were clueless.

Leave a Reply