I'm trying to connect to an Oracle XE database using sqlplus.exe with the following command:


Yes that's right, the '@' symbol is the last letter of the password, and needs escaping. :(

Many thanks.

See also Oracle pl-sql escape character (for a ‘&’)



Connect SYSTEM/"password@"

or if you need to specify a TNSName

Connect SYSTEM/"password@"@tnsname
  • 1
    I've just tried this with a password without the '@' and it works with the double quotes.... Thumbs up Gauthier and thanks! – ian_scho Nov 30 '10 at 15:43

Try like this. Connect SYSTEM/\"password@\"@tnsname

  • 1
    This has been already answered six years ago and your answer doesn't contribute anything new. – Sven Nov 15 '16 at 10:43
  • This new answer added the escaped double quotes and helped me out! – lanes Aug 21 at 6:51

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.