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 LazyDBA home page