Explicit Cursor !! Want list of all columns ?

[surajitmitra78]

Hi,

I have a dynamic cursor.

declare....
begin..
open cur_test1 for 'select * from table1;';
...

now in the above scenario i don't know what all columns are available in the table 'table1'.

At runtime is it possible to know the list of all columns in the cursor and how do i point to those columns for value.

Please help.