Re: LIMIT clause in ORACLE???
| From: | Manuel Lemos | Date: | Mon, 03 Jul 2000 16:34:29 +0000 |
| Subject: | Re: LIMIT clause in ORACLE??? | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-4558@lists.php.net to get a copy of this message | ||
Hello Mustansir,
On 30-Jun-00 10:06:52, you wrote:
>Is there anything similar in Oracle to the LIMIT clause in MySQL...
>as in:
>"select * from table1 limit 1,10"
Not that simple. I believe that you have to use the Oracle DBMS_SQL
package to get that close.
Meanwhile you may want to try Metabase database abstraction package that
lets you do what you want with Oracle and other supported DBMS just by
executing a single MetabaseSetSelectedRowRange($database,$first,$limit)
command before executing a query.
http://phpclasses.UpperDesign.com/browse.html/package/20
Regards,
Manuel Lemos
Web Programming Components using PHP Classes.
Look at: http://phpclasses.UpperDesign.com/?user=mlemos@acm.org
--
E-mail: mlemos@acm.org
URL: http://www.mlemos.e-na.net/
PGP key: http://www.mlemos.e-na.net/ManuelLemos.pgp
--