Referring to Column By Position

[jtanner]

Greetings,

How can I refer to a column\field in a cursor via the position of the column rather than by its name?

Psuedo Code (not working):

CURSOR c IS SELECT * FROM emp;
...
FOR rec IN c
LOOP
htp.p('<tr>' ||
   '<td>' || rec(1) || '</td>' ||
   '<td>' || rec(2) || '</td>' ||
   '</tr>');
END LOOP;

Thanks,

JT

 

[LKBrwnDBA]

You could combine a 'BULK COLLECT' with PL/SQL arrays.

----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb