Re: Query Data

From: Martin Drautzburg <drautzburg_at_altavista.net>
Date: 10 Apr 2001 19:43:23 +0200
Message-ID: <87r8z0y7k4.fsf@altavista.net>

"terrylaw" <terrylaw_at_ms22.url.com.tw> writes:

> May I Use SQL language to limit results from Oracle database ? If I
> select from database with very huge results, Could I specify data
> cursor from No. 100 to No 200 with SQL Description?

I don't think so. You can limit the number of returned rows by using the ROWNUM pseudocolumn but you cannot use something like

where rownum between ...

becuase the rownum is computed at the very end of the query, so

where rownum = 2

will never return anything, because the first row does not fulfill the clause and thus the 2nd row would be the 1st row to be returned which again does not have a rownum=2.

You can do such things with cursors. Received on Tue Apr 10 2001 - 12:43:23 CDT