oracle query vs. $sql->fetch()

From: blackdog <cljlk_at_hotmail.com>
Date: 4 Jan 2006 09:13:22 -0800
Message-ID: <1136394802.686119.200980@g14g2000cwa.googlegroups.com>

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. Received on Wed Jan 04 2006 - 11:13:22 CST