OraFAQ Forum: Server Administration » Re: Is it possible to replace Double quotes (") with two single quotes ('') ?

Home » RDBMS Server » Server Administration » Re: Is it possible to replace Double quotes (") with two single quotes ('') ?

Tue, 16 May 2000 07:46

Thierry Van der Auwera
Messages: 44
Registered: January 2000

Member

Hallo Halvor,

Just do following :

UPDATE table_test
SET column1 = REPLACE(column1,'"','''''')
WHERE column1 LIKE '%"%';

Greetings,

Thierry.

Previous Topic:	standard or enterprise Edition
Next Topic:	Oracle 8/8i on SCO NonStop Cluster for UnixWare 7

Goto Forum:

]

Current Time: Thu Apr 18 04:16:41 CDT 2024