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!

Validating dynamic SQL query in PL\SQL block

2751678Sep 15 2014 — edited Sep 19 2014

Hi,

Is it possible in oracle 11g to validate the dynamic SQL query. For example, I have an input variable in a procedure which will be expected to have the query as its value. Can we validate the query using any DBMS inbuilt functions or procedures. If there is any way can you please provide with an example.

Thanks in advance

Maneesh

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 17 2014

Added on Sep 15 2014

9 comments

3,237 views