RE: :Oracle function

John Scoles wrote:
> Oracle doesn't have this feature so DBD::Oracle doesn't either.
> This has cropped up many times before So you can blame Oracle on that.
> Thier logic (as it was explained to me) is
>
> "How could you get the number of rows you are going to fetch without
> counting them all first?"

This makes sense to me, as it enables Oracle to continue to build the
result set on the server while piping rows to the client. It means that
the client doesn't have to wait for the server to build all the
(possibly millions) of rows from disk before it can start transferring
and processing them.

- Philip
Philip.Garrett [ Mi, 11 April 2007 19:19 ] [ ID #1685032 ]
Perl » perl.dbi.users » RE: :Oracle function

Vorheriges Thema: DBD::Oracle 1.19 tests core against Oracle 10.2.0.1 - Solaris build
Nächstes Thema: Internal Error while compiling Pro*C program