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)
error_proneAsked:
Who is Participating?
 
GGuzdziolConnect With a Mentor Commented:
Yes it is.

and (colA not in('A' || CHR(38) || 'A ABCD EFG','A ' || CHR(38) || ' A ABCD EFG') or colA is null)
0
 
johnsoneSenior Oracle DBACommented:
Yes, it is because of the ampersand.

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.
0
All Courses

From novice to tech pro — start learning today.