Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: PL/SQL escapes
You can use 2 ampersands; Or, you can concatenate the & separately. For example,
UPDATE my_table SET my_column = 'TEST' || '&' || 'XYZ' where my_column='TEST'; Received on Tue Jan 13 1998 - 00:00:00 CST