Enable/Disable Bind Variable in PL/SQL

When we execute a series of insert statements which contains ampersand (&) or colon (:), PL/SQL will prompt us for an input. Most of the cases, we want to avoid this. Here is a simple tips.

set define off


Then, to turn back on, do the opposite as below.

set define on