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

Re: fetch entire table

2004-08-15 Thread Harald Fuchs
In article <[EMAIL PROTECTED]>, Xinyu Wen <[EMAIL PROTECTED]> writes: > 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-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

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 f

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 wi