How do I escape double quotes in oracle query?

Question

I have some text fields in the oracle table, which have double quotes. How to escape them in a select query, so that I can use it in PHP?

Accepted Answer

You should be able to do a

```
SELECT REPLACE(your_column, '"', '\"') AS your_escaped_column
FROM your_table;
```

Solution