Re: fetch entire table

2004-08-16 Thread Jared Still
On Sat, 2004-08-14 at 11:53, Harald Fuchs wrote: Why do you want to use Perl for that? Every DB has some export feature that's optimized for exactly what you ask for. You are obviously not an oracle user. Jared

Re: fetch entire table

2004-08-15 Thread Xinyu Wen
Thanks. Looks good and I will give it a try. -- Adam. On Sat, 14 Aug 2004 09:28:17 -0700, Jared Still [EMAIL PROTECTED] wrote: On Wed, 2004-08-11 at 09:34, Xinyu Wen wrote: Hi, I would like to know if there is a better way to fetch an entire table to a file (the file has to be tab

Re: fetch entire table

2004-08-14 Thread Jared Still
On Wed, 2004-08-11 at 09:34, Xinyu Wen wrote: Hi, I would like to know if there is a better way to fetch an entire table to a file (the file has to be tab delimited) instead of using fetchrow_array function? Fetchrow_array is working fine but slow to work with a big table. Thanks,

fetch entire table

2004-08-13 Thread Xinyu Wen
Hi, I would like to know if there is a better way to fetch an entire table to a file (the file has to be tab delimited) instead of using fetchrow_array function? Fetchrow_array is working fine but slow to work with a big table. Thanks, Adam.

Re: fetch entire table

2004-08-13 Thread Sapet Frederic
On Wed, 11 Aug 2004 11:34:00 -0500 Xinyu Wen [EMAIL PROTECTED] wrote: Hi, I would like to know if there is a better way to fetch an entire table to a file (the file has to be tab delimited) instead of using fetchrow_array function? Fetchrow_array is working fine but slow to work with a

Re: fetch entire table

2004-08-13 Thread Hardy Merrill
Not sure if this is what you're looking for, but do perldoc DBI at a command prompt and search for selectall_arrayref, selectall_hashref, and fetchall_arrayref. Hardy Merrill Xinyu Wen [EMAIL PROTECTED] 08/11/04 12:34PM Hi, I would like to know if there is a better way to fetch an