#13907 [Com]: Oracle Fetch row by row number

ID: 13907 Comment by: michael.mauch@gmx.de Reported By: jh@synergy.cx 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] maxim@php.net 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] jh@synergy.cx 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