Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: PL/SQL formatting output question
Won't this code only work if the result of your select is a single row
? If you have more than one row in your results set you will have to
declare a cursor, open it, and then use the fetch command to move
through your results set one row at a time. This not only allows your
one at a time style of processing, but is actually mandatory.
![]() |
![]() |