How to loop through columns selected by select clause
396540Jun 3 2004 — edited Jun 3 2004Hi,
I am having a select statement which is generated dynamically and the columns within it are also generated dynamically.
Select col1, col2, col3 from table1 where rowid = 'xxxx'
This will return a single row and columns within it, now i want to loop through the column values and store in it varray and return it.
Can somebody please show me how can i do this.
Thanks!