have you ever faced a problem when you executed a SQL code sent to you by a developer and the below pop window appeared ??

to avoid this just add the following starting statement:

set define off

When you have ‘&’ inside SQL Script you need to specify “set define off” at the beginning of the code .  It will Turn off substitution variables.