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.