sqlplus CONNECT command with an '@' symbol in the password

Question

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

CONNECT SYSTEM/password@

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

Many thanks.

score 8 · Answer 1 · answered Nov 15 '16 at 09:21

8

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

answered Nov 15 '16 at 09:21

score 5 · Accepted Answer · edited Oct 03 '15 at 00:16

5

Try

Connect SYSTEM/"password@"

or if you need to specify a TNSName

Connect SYSTEM/"password@"@tnsname

edited Oct 03 '15 at 00:16

Falcon Momot

answered Nov 23 '10 at 15:17

Gauthier

2 Answers2