Bringing data from sql to oracle, I need to generate a query from Oracle where I am sending a query to sql to replace “ in a text field.
So, in sql I want to generate a query in oracle “
SELECT REPLACE(TEXT, '“', '"'). It works fine if i run this directly on SQL server. But, since I need to store this query in Oracle first and then read it, oracle converts it to a junk “
SELECT REPLACE(TEXT, '<somejunk>, '"'). Does anyone know how to make oracle literally take “. I tried ESCAPE and \ but nothing works