How to replace single-quote with double-quote in sql query - oracle 10g ?

Question

How can I replace single-quote (') with double-quote (") in sql query - oracle 10g?

Answer 1

This should work:

UPDATE myTable
SET myField = REPLACE(myField, '''', '"');

Answer 2

You can use Ansi-codes as well, to make it more crystal what is happening:

SELECT someString
      ,replace(someString, Chr(39), Chr(34)) as replacedString
FROM   (SELECT ' abc ' || Chr(39) || ' def ' as someString
        FROM   Dual)

39 is a single quote, 34 a double quote