Outputting a rowtype
Posted on 2000-03-24
Is there a way to output a rowtype variable generally?
For instance, I want to have a cursor which selects into my rowtype variable, and I want to output every column. But the table structure may change, so I would like to have it still output all columns, without having to change anything.
The cursor has select * - so thats covered.
The variable is of type ROWTYPE, so that covers any changes.
But printing out the results doesn't seem to be straight forward...
I can't seem to use any sort of loop through the columns by number?
Can I use the user_tab_columns table and somehow integrate the column names with the rowtype variable to output all columns?
What I need is something like
select * from table into rowtype_variable;
for i = 1 to rowtype_variable.num_columns
(Can it be that simple?)