Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

21c XE: can i execute a stored query in a table column may be CLOB or VARCHAR2 type

SmithJohn45Oct 26 2023

may be its a nonsense query but i was thinking about it. i know there are various ways around here instead of this approach to store a SQL statement in table.

if there is a SQL statement stored in a table in CLOB or VARCHAR2 type column … can i return it through a function and execute in anonymous pl/sql block or a procedure etc. if yes, please help on how to's, if not please brief.

regards

This post has been answered by Barbara Boehmer on Oct 26 2023
Jump to Answer
Comments
Post Details
Added on Oct 26 2023
5 comments
92 views