Re: how to store as a varchar2 a string containing single quotes

From: Anatoly Moskovsky <avm_at_trais.com.ua>
Date: Wed, 12 Sep 2001 10:18:12 +0300
Message-ID: <TRS15146425B@trais.com.ua>

Hi!

• On september 12 DMScott wrote:

 D> I am very interested to store in a database the following kind of  D> string data, which correctly resembles part of an SQL command:

 D> decode( handled_status, 'F', 0, 'U', 1, 'S', 2, 3 )

Update mytable Set mycol = 'aa = ''string''' Where ...

Bye

---

Anatoly Moskovsky, Oracle Developer avm_at_sqlbatch.com [SQL Batch/Oracle, DBA tools, reverse engineering, scripting extensions]: http://sqlbatch.com/sb/ Received on Wed Sep 12 2001 - 02:18:12 CDT