Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: SELECT
It is fully capable, but the license agreement has restrictions. They are
relying on your honesty.
Again to solve this "rownum" problem:
Look at the AskTom web site. Sure he has it.
http://asktom.oracle.com/pls/ask/f?p=4950:1:
http://asktom.oracle.com/pls/ask/f?p=4950:8:138613::NO::F4950_P8_DISPLAYID,F
4950_P8_CRITERIA:555422909506,%7Brownum%7D
and
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:127412348
064
Auto incriment see sequence numbers in the documentation. If you are
looking for rows x through y in the table they really don't have a meaning
in sql. (What you are really saying is get me the tuples from the xth tuple
to the yth tuple in an unordered and unlimited - no restriction on the
predicate - set of data. What the database - any sql database serves up in
that case could be different each time you ask.) On the other hand, if you
have a specific ordered result set - e.g. the list of employees who are
managers ordered by hire date which ones were hired 10th thru 30th then that
makes some sence.
Jim
"Uli Herberg" <uh_de_at_yahoo.com> wrote in message
news:9oi4eb$ro5$05$1_at_news.t-online.com...
> "Himansu" <m.himansu_at_sify.com> schrieb
> > In Oracle you have got a rownum for each row the select stmt fetches.
> > So you can restrict the no of rows by writting:
> > SELECT * FROM tablename where rownum <= 10;
>
> Thanks. But it only works for rownums < x and not for rownums between x
and
> y. (Davide wrote: "Conditions testing for ROWNUM values greater than a
> positive integer are always false").
> AFAIK the only possibility to do this is to add a column "id" or the like
> and to auto_increment the number. Is this possible in Oracle (I only know
it
> works in MySQL)? Then I could perform SELECT FROM tablename WHERE id >= 10
> AND id <= 20
> Is this correct?
>
> Another Question: I have seen one can download Oracle9i from
www.oracle.com.
> Is this a trial version? Or a limited version for private purposes?
>
> Thanks in advance
> Uli
>
>
Received on Sat Sep 22 2001 - 10:12:27 CDT