ID:               13907
 Comment by:       [EMAIL PROTECTED]
 Reported By:      [EMAIL PROTECTED]
 Status:           Open
 Bug Type:         Feature/Change Request
 Operating System: all
 PHP Version:      4.0.6
 Assigned To:      maxim
 New Comment:

Probably he/she doesn't really need a new function, but only a hint how
to simulate the limit/offset syntax of MySQL/Postgresql.

Without the help of <http://www.dclp-faq.de/q/q-oracle-limit.html> (in
German, but not much text), I certainly would not know how to do it,
although I asked our local SQL gurus.


Previous Comments:
------------------------------------------------------------------------

[2003-01-29 08:59:05] [EMAIL PROTECTED]

Well, this wouldn't make much sence as this should be controlled by
your SQL. What's the point to grab the whole table in your buffer to
then fetch only a few rows somewhere in the middle?

Anyhow, will assign it to myself for now.

------------------------------------------------------------------------

[2001-11-02 05:37:16] [EMAIL PROTECTED]

Currently there's no way of fetching a row by row number.
OCIFetchStatement() fetches all rows returned by a query. 
OCIFetchInto() only allows to return the NEXT row.

It would make sense to be able to selectively fetch a subset of rows or
single rows by row number for large
row lists.


------------------------------------------------------------------------


-- 
Edit this bug report at http://bugs.php.net/?id=13907&edit=1

Reply via email to