Change the define setting to a character that you won't be using.

SQL> select '&z' from dual;
[Email Address Removed] select '&hey' from dual;
Enter value for hey:


SQL> set define `
SQL> select '&z' from dual
'&
--
&z

1 row selected.



--Jeff

-----Original Message-----
From: Bill Ducker [mailto:bill.[Email Address Removed] Monday, June 30, 2003 1:28 PM
To: LazyDBA.com Discussion
Subject: Another Question


update TABLE_NAME set column_name = 'ABCDEFG'
where column_name = 'UVWX&Z';

This looks like it should be easy, BUT... it interprets the ampersand ('&')
in the string literal as some sort of variable, stops, and issues this
statement:

Enter value for Z:

How to I get around this problem?




--------
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
Oracle LazyDBA home page