php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

Request #13907 Oracle Fetch row by row number
Submitted: 2001-11-02 05:37 UTC Modified: 2006-04-03 09:57 UTC
From: jh at synergy dot cx Assigned: maxim (profile)
Status: Not a bug Package: Feature/Change Request
PHP Version: 4.0.6 OS: all
Private report: No CVE-ID: None
View Developer Edit
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: jh at synergy dot cx
New email:
PHP Version: OS:

 

 [2001-11-02 05:37 UTC] jh at synergy dot 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.

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2003-01-29 08:59 UTC] 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.
 [2003-01-29 12:07 UTC] michael dot mauch at gmx dot de 
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.
 [2003-01-30 06:23 UTC] maxim@php.net 
It is probably true. Will soon close it as bogus. I am still curious to see whether there is any "technical" way for it through OCI first.
 [2003-01-30 06:29 UTC] maxim@php.net 
Just to follow up:

Yes, to select the first 6 rows you can use subselects (besides there are other methods):

SELECT * FROM
  (SELECT ename, hiredate FROM emp ORDER BY hiredate)
WHERE ROWNUM < 6

Nevertheless, you still have selected the full stream in the subselected query *and* from the received result you've extracted the first 6 rows.

What I am wondering here is, whether it could actually make any sense of having the offset functions that pretty much limit the Fetch loop inside OCI8 extension.

Doesn't seem to me a clean method, but if this saves on speed and functionality/usability there is then a space for this function.

Will look into it in details
 [2006-04-03 09:57 UTC] tony2001@php.net 
Yes, you have to emulate LIMIT in Oracle using 3 nested SELECTs. This is the way it works.
 
PHP Copyright © 2001-2025 The PHP Group
All rights reserved. 		Last updated: Wed Jan 15 09:01:28 2025 UTC