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.