@Cassidy said:
@Nagesh said:
You can have @ character in the password. Just do not use sql plus to make connection.Incorrect.@Nagesh said:
It appear that the warning was put in there for dba who frequently used to use sqlplus tool to make connections.No, the warnings were there for people who didn't understand that it was a reserved character and needed to be escaped. That's Oracle being patronising by making out it can't be used when it can in certain circumstances.
I am basing this on my own testing. I have oracle database to practice this on. Do you? Make user. Create password with "@" character. Then use java to make connection.
It will make successful connection. What part of that is incorrect? I am going to make guess and state taht you're refer to my second comment. You can make sqlplus to make connection.