Re: cursor name

"michael" <mxa_at_yahoo.com> a écrit dans le message de news:57e25f29.0407031142.16ff7d54_at_posting.google.com...
> 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
> -----------------
> a=577
> ...
> ------------------
>
> 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

Tom Kyte's "print_table" procedure is what you need. Have a look at:
http://osi.oracle.com/~tkyte/print_table/

--
Regards
Michel Cadot