Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: PLS/SQL: OK to use EXIT in a cursor FOR LOOP ??
I prefer using:
cursor_name.open
cursor_name.fetch (a);
while cursor_name%found and cursor_name%rownum < 10 loop
. . .
cursor_name.close;
I'm not sure about the syntax, but the main idea is to transform your FOR loop to WHILE loop. (which you can control the exit condition)
Haggai. haggai_shachar_at_hotmail.com
Andy Hardy wrote in message ...
>Hello,
>
>I used a cursor FOR LOOP to work my way through some ordered data. I now
>want to limit the number of rows considered using something like ROWNUM.
>However, as ROWNUM is considered before ORDER I cannot simply add it to
>the query.
>
>I *could* create a FOR LOOP with an EXIT clause based on the %ROWCOUNT,
>but wonder if this is the *correct* way to do this or would it upset the
>Oracle cursor management?
>
>Any thoughts?
>
>E.G
>
>CURSOR my_csr
>IS
>SELECT a, b, C
> FROM my_table
> ORDER BY d
>;
>
>FOR v_data IN my_cursor LOOP
> EXIT WHEN my_cursor%ROWCOUNT > 5;
> -- do the real work
> --
>END LOOP;
>
>--
>Andy Hardy. PGP key available on request
>===============================================================
Received on Tue Jun 15 1999 - 01:10:34 CDT