Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: counting rows in loop
laura_galimberti_at_hotmail.com wrote in news:1174173427.941633.219250
@l75g2000hse.googlegroups.com:
> Hi,
> I am trying to learn pl/sql and I need some help, please.
> I have written a package with a cursor and a loop, which returns a
> file with some lines.
> The last step I have to do is to write something that returns the
> number of lines produced in the file: i.e, if the loop retuns 356
> lines, I have to write something that calculates that figure and
> returns the result in the last line.
>
> I was told that I need to create a variable and place it somewhere at
> this point to do the calculation:
>
> END LOOP;
>
> Utl_File.Put(l_Output, 'end of file');
>
> Utl_File.Fclose(l_Output);
>
> I do not quite understand what to do or how to do it, can someone
> help?
> Thanks
>
>
please see previously posted response in other forum. http://www.orafaq.com/forum/t/78554/74940/ Received on Sat Mar 17 2007 - 19:33:38 CDT