Re: How to move cursor to skip couple of record.

I have the same question and your answer didn't help me because:

1. When v_counter <> 1 I get an empty resultset.
2. What if my query has an "order by somefield"? Even with v_counter = 1, it doesn't returns the first 10 rows of the whole query.

Thanks in advance.
Please also replay to pablo_at_dirpat.com.ar

Oracle's SQL Reference says about 1) :

"Note that conditions testing for ROWNUM values greater than a positive integer are always false. For example, this query returns no rows:

SELECT * FROM emp WHERE ROWNUM > 1;"

In article <373a89fb.0_at_145.227.194.253>,   "Mark Gumbs" <mgumbs--AT--hotmail.com> wrote:
> You may have to keep a counter in your
application on what records you want
>
> e.g in your application, counter = 20
>
> cursor c_data(v_counter in number) is
> select empno, ename
> from emp
> where rownum >= v_counter
> and rownum < v_counter + 10;
>
> You then call the cursor in your application
with a parameter of counter
> .....for records in c_data(counter)...
>
> HTH
>
> Mark
>
> --------------------------
>
> Peizhong Wu wrote in message

<3739DB52.D382C508_at_umich.edu>...
> >What I am trying to do is to implement a web
application. Say, client can
> get a
> >
> >page of 10 rows, then he can press the
"Previous 10" or "Next 10" button to
> get
> >
> >more.
> >
> >I do not know how people do this.
> >
> >Thanks
> >
> >Jerry Gitomer wrote:
> >
> >> Hi,
> >>
> >> You can, but you shouldn't. Oracle does
not store data in a
> predictable
> >> sequence. If you are inserting a new row
into a table it may be inserted
> >> anywhere. As a result you have no way of
knowing what the 10th row in
> the
> >> table contains. If you have already
retrieved the 10th row in the table
> and
> >> you know you will want to access again just
save the unique key or the
> rowid
> >> of the row and use one or the other when you
want to access that same row
> in
> >> the future.
> >>
> >> regards
> >>
> >> Jerry Gitomer
> >>
> >> Peizhong Wu wrote in message

<3739C2C5.31D7B844_at_umich.edu>...
> >> >HI,
> >> >
> >> >How can I move cursor to #10 record without
fetch the first 9 records?
> >> >
> >> >Thanks
> >> >
> >> >
> >
>
>

--== Sent via Deja.com http://www.deja.com/ ==-- ---Share what you know. Learn what you don't.--- Received on Fri May 14 1999 - 15:21:52 CDT