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!

count columns in dynamic sql

Alistair LaingJul 30 2010 — edited Jul 30 2010
Hi,

I wondered whether you could count the number of columns a dynamic sql had.

very simple Eg.

Say I had a string 'select 1 ,2,3,4,5,6 from dual' and I excute that immediate. Is there a way to count the number of column i.e 6 columns.

I know of DBA|USER|ALL_TAB_COLUMNS but it could be a few columns from different columns and it would not be from a view.

Thanks for you advice/help.
This post has been answered by ravikumar.sv on Jul 30 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 27 2010
Added on Jul 30 2010
17 comments
9,813 views