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!

how to get the columns, tables of a select statement?

Allen SandiegoApr 13 2010 — edited Apr 13 2010

hi all,

we have a table that contains a column for storing select statements... i want to be able to get the number of columns, tables in this query. how can i do that?

i'm currently looking for something similar to the all_tab_columns information but i'm not sure if there is such a thing with just select statements.

any ideas?

thanks
allen

Locked Post

New comments cannot be posted to this locked post.

Locked on May 11 2010

Added on Apr 13 2010

9 comments

949 views