error_prone
asked on
Variables Keeps Popping Up
This line of code in TOAD is causing a Variables pop up to come up everytime I try to run this is in the sql editor. Is it because of the ampersand in the string?
and (colA not in('A&A ABCD EFG','A & A ABCD EFG') or colA is null)
and (colA not in('A&A ABCD EFG','A & A ABCD EFG') or colA is null)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
In SQL*Plus, you would use the "set define off" command to turn that off, or you can use the escape character (usually \) to have it not do the variable substitution. Another way around it is to replace the & with CHR(38).
I don't use TOAD, so I cannot tell you exactly how you change those settings in that tool.