Hello,
Cynic wrote:
>
> Hi there,
>
> I'm in a situation where I need to produce a small app
> on top of an Oracle server really quickly. I'm quite a
> seasoned developer, but have only experience with MySQL
> so far. It's my understanding that Oracle lacks the
> MySQL's "LIMIT" feature. Looking at the OCI section of
> the PHP manual, it also looks like there's no
> OCIDataSeek() or some equivalent. Since the app I need
> to build will be a standard report builder with paging,
> I need this functionality. What is the common way to
> achieve this? Always fetch all rows, cycling through the
> resultset, discarding the records that preceed the one
> I want to start displaying with, and quit when I reach
> the one where the page should end?
>
> Is there a PHP + OCI tutorial somewhere?
>
> I need an intro to Oracle, and I need it now. :(
You may want to try Metabase. It is a database abstraction package among
many other things it will achieve a similar effect of using the MySQL
LIMIT clause, except that it works portably with all supported
databases, including Oracle with OCI API.
All you need to do is to call
MetabaseSetSelectedRowRange($database,$first,$limit) right before
executing a query, and it will return a result set with just the range
of rows that you selected.
Metabase is free and is available here:
http://phpclasses.UpperDesign.com/browse.html/package/20
Regards,
Manuel Lemos
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]