Oracle: sql update on field containing sql itself [message #683899] |
Wed, 03 March 2021 05:44 |
|
apisto
Messages: 2 Registered: March 2021
|
Junior Member |
|
|
Hello @all,
may be someone of our community can help regarding a special update-sql.
I have a table/field named for example SQL_TAB/SQL_FIELD (varchar 3500)
The SQL_FIELD itself contains a sql-statement like "select * from anytab where field1 = 'ABC'".
This sql statement within SQL_FIELD i want to change using sql. Problem is the " ' " within the sql-statement. If i want to change field1 to "where field1 in ('ABC','FTG','2ab')" i have a conflict with the string sign.
My first idea was to change a oracle environment variable from ' into § or something like that. But i did'nt find such variable.
Any idea, how i can proceed?
Many thanks for any idea,
Jens
|
|
|
|
|