count columns in dynamic sql
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.