Re: Limiting the result set in php4+OCI
| From: | Fred Cai | Date: | Mon, 21 Aug 2000 08:06:57 +0000 |
| Subject: | Re: Limiting the result set in php4+OCI | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-2198@lists.php.net to get a copy of this message | ||
You could use sub query and rownum to act the same as the limit clause;for
example,
in mysql:
select * from table_name where ... limit 30;
in oracle:
select * from (select * from table_name where ...) where rownum<30;
"Krish" <krishnakumar_avanoor@yahoo.com> wrote in message
news:8n1dgo$ii$1@toye.php.net...
> Hello,
>
> How can one retrive a subset of the result set using OCI ? is there
anything
> similar to the limit clause in Mysql?
>
> Please help.
>
> Regards
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net
> For additional commands, e-mail: php-db-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net
>