Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: PL/SQL escapes

Re: PL/SQL escapes

From: Sandy Thrasher <sandra.thrasher_at_MCI2000.com>
Date: 1998/01/13
Message-ID: <SNyu.1476$YH1.559240@news.internetMCI.com>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US