Originally posted by sayan maity:
Hi Paul,
I tried this with SQLPlus but while implementing I will be doing storing the ampersand sign in the database using JDBC connection.
Please let me know whether it will be a problem while using JDBC to store the data.
Thnaks,
Sayan Maity
It is SQL*Plus itself that is treating &[
string] as a substitution variable; JDBC will not do that and you can use an ampersand with JDBC just like any other normal character.
You can also turn off this feature of SQL*Plus with "SET DEFINE OFF" or change the chracter with "SET DEFINE x", where x is your new prefix charachter for variable substitution. And of course, "SET DEFINE ON" undoes, "SET DEFINE OFF".