To prevent execute oracle sql script to prompt input dialog

It is very simple, just a single line command.

SET DEFINE OFF;

After execute that command the oracle will not prompt the input dialog when your SQL query contains '&' char.

Hope this help ~