Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: SELECT rows range from a view?

Re: SELECT rows range from a view?

From: Giovanni Azua <bravegag_at_hotmail.com>
Date: Sat, 1 Jun 2002 15:42:06 +0300
Message-ID: <adajam$vh4p8$1@ID-114658.news.dfncis.de>


thank you!!!!! :-)

"Thomas Kyte" <tkyte_at_oracle.com> wrote in message news:adahjj02619_at_drn.newsguy.com...
> In article <ad9ahf$ujsjq$1_at_ID-114658.news.dfncis.de>, "Giovanni says...
> >
> >Hi all,
> >
> >How can one retrieve only rows X to Y from a *VIEW*?
> >
> >I know it is possible using the ROWID and ROWNUM
> >but what from a complex view?
> >
> >SELECT *
> > FROM tableX
> > WHERE rowid in (
> > SELECT rowid FROM tableX
> > WHERE rownum <= 7
> > MINUS
> > SELECT rowid FROM tableX
> > WHERE rownum < 5);
> >
> >but if TableX is a VIEW I get the error:
> >cannot select ROWID from a join view without a key-preserved
> >table
> >
> >Thanks in advance,
> >Giovanni
> >
> >
>
>
> Just
>
> select *
> from ( select a.*, rownum rnum
> from ( YOUR_QUERY_GOES_HERE ) A
> where rownum <= :MAX_ROW )
> where rnum >= :MIN_ROW;
>
>
> Thats all -- no rowids, no minus.
>
> --
> Thomas Kyte (tkyte@oracle.com) http://asktom.oracle.com/
> Expert one on one Oracle, programming techniques and solutions for Oracle.
> http://www.amazon.com/exec/obidos/ASIN/1861004826/
> Opinions are mine and do not necessarily reflect those of Oracle Corp
>
Received on Sat Jun 01 2002 - 07:42:06 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US