Set Define Off

Database: Oracle / MySQL

When load sql from a batch, if there is an "&" (ampersand), the commander (eg. sqldeveloper) will treated it as "substitution variable", will prompt you to input the values of variable

This can be turn off by type in command
SET DEFINE OFF


ref: http://blog.andrewbeacock.com/2008/09/using-ampersands-without-variable_15.html