R: [PHP-DB] returning rowset results from oracle, stored procedur es
| From: | Roberto Sartor | Date: | Thu, 02 Nov 2000 14:10:37 +0000 |
| Subject: | R: [PHP-DB] returning rowset results from oracle, stored procedur es | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-4132@lists.php.net to get a copy of this message | ||
Ciao
Roberto
> -----Messaggio originale-----
> Da: jeff@surfrat.com [mailto:jeff@surfrat.com]
> Inviato: giovedì 2 novembre 2000 4.18
> A: php-db@lists.php.net
> Oggetto: [PHP-DB] returning rowset results from oracle, stored
> procedures
>
>
>
> does anyone know how to return multiple rowsets from an oracle stored
> procedure.
If I understand well, you could use a dynamic cursor as a IN/OUT parameter.
>
>
> does anyone know how to limit the number of rows that are
> returned from
> a select query in oracle. I have a query that returns 100,000
> rows. I only
> want to return the first 10 rows.
SELECT ... FROM ... WHERE ROWNUM<=row number i need
P.S.: ROWNUM clause shouldn't be used with an ORDER BY.
>
>
>
>
> --
> 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
>