Home » RDBMS Server » Server Administration » Re: Is it possible to replace Double quotes (") with two single quotes ('') ?
Re: Is it possible to replace Double quotes (") with two single quotes ('') ? [message #370201] 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: Mon Dec 05 13:02:47 CST 2022