Technical blog on Java/JSP You can contact me at email@example.com
Tuesday, May 17, 2011
How to disable enable user input in queries
Many times it might have been required to insert & symbol in the value of a column in SQL.
How do you guys pass that.
There might be more than one ways to do that
Here is one of them.
set scan off;
This will disable SQL to ask for user input if any subsequent query contains & symbol.
You can ofcourse use set scan on; again to enable it back.
Share to Twitter
Share to Facebook
Share to Pinterest
Post a Comment
Post Comments (Atom)