set define off and ‘&’ in your SQL Code

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

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.





Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s