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?

Answer 1

Odds are, if you are trying to do this you are dealing with a SQL Injection vulnerability. Please Google this and think about what you're doing.

Answer 2

You should be able to do a

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