[Israel.pm] limit rows issue of class::dbi and oracle

guy keren choo at actcom.co.il
Mon Oct 16 08:27:31 PDT 2006


you can limit the number of raws via an SQL keyword called 'limit'.
put it at the end of the query, followed by the number of rows to get.

there are a few ways to play with it - depending on your DB.

--guy

On Mon, 16 Oct 2006, Michael Gang wrote:

> Date: Mon, 16 Oct 2006 12:45:09 +0200
> From: Michael Gang <michaelgang at gmail.com>
> Reply-To: Perl in Israel <perl at perl.org.il>
> To: perl at perl.org.il
> Subject: [Israel.pm] limit rows issue of class::dbi and oracle
>
> Dear All,
>
> I want to limit the row number in a search in class::dbi. I am working
> on an oracle database.
>
> Can someone help me in this issue ?
>
> Best regards,
> Michael
> _______________________________________________
> Perl mailing list
> Perl at perl.org.il
> http://perl.org.il/mailman/listinfo/perl
>

-- 
guy

"For world domination - press 1,
 or dial 0, and please hold, for the creator." -- nob o. dy




More information about the Perl mailing list