Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: oracle query vs. $sql->fetch()
"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