Contrary to the last time I checked, sqlplus is able to write out via spool redirection slightly faster than perl can. I guess Perl loses out on this test. Jared On Wed, 29 Sep 2004 11:12:22 -0700, Jared Still <jkstill@xxxxxxxxx> wrote: > On Wed, 29 Sep 2004 14:03:33 -0400, Goulet, Dick <dgoulet@xxxxxxxx> wrote: > > look into UTL_FILE package. > > Ugh. > > Use perl. > > It will be *much* faster than writing to a file through utl_file, and with > no limitations. > > It is also *very* easy to write. > > Jared > > -- > Jared Still > Certifiable Oracle DBA and Part Time Perl Evangelist > -- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist -- //www.freelists.org/webpage/oracle-l