Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> cursor name
Hi,
is there anyway to retried cursor element's name ?
if ord_dtl has 3 elements a,b and c then
if wish to print
a=1234 b=xyx c=sssss -----------------
for myrec in ( select * from ord_dtl )loop dbms_Output.put_line(myrec%element || ' = ' .. ); end loop;
perl has a DBI function to do that , but I am trying to do it in pl/slq.
thanks
Michael
Received on Sat Jul 03 2004 - 14:42:04 CDT
![]() |
![]() |