Oracle: sql update on field containing sql itself [message #683899] |
Wed, 03 March 2021 05:44 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/5272aa2fc0283600a8818b895d7f43ff?s=64&d=mm&r=g) |
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
|
|
|
|
|