Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: oracle query vs. $sql->fetch()

Re: oracle query vs. $sql->fetch()

From: Turkbear <john.g_at_dot.spamfree.com>
Date: Wed, 04 Jan 2006 11:17:04 -0600
Message-ID: <am0or1luui72pcauk2ecapgnq5cbgtg83c@4ax.com>


"blackdog" <cljlk_at_hotmail.com> wrote:

>I use sql> select column1, column2 from a_table;
>I got three output.
>
>But,
>
>if I use perl script as below:
>
>..........
>$sql = qq{ select column1, column2 from a_table };
>.............
>-------------
>while( $sql->fetch() ) {
> print "$column1, column2\n";
> }
>
>I got only two out put, lost the first line of output.
>
>please help.

For those who do not know perl, what does

while( $sql->fetch() ) indicate..

Is it just a test for EOF ? Received on Wed Jan 04 2006 - 11:17:04 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US