Re: writing to text file
From: Gerrit-Jan Linker <gjlinker_at_oraxcel.com>
Date: Sun, 8 Jul 2001 17:42:40 +0100
Message-ID: <9ia2eb$ovm$1_at_neptunium.btinternet.com>
Date: Sun, 8 Jul 2001 17:42:40 +0100
Message-ID: <9ia2eb$ovm$1_at_neptunium.btinternet.com>
Consider going via Excel. I've written SQL*XL that fetches your data straight into Excel. From there you can simply use Excel's Save As feature to save it to any format you like.
SQL*XL can be found at www.oraxcel.com
Regards,
-- Gerrit-Jan Linker SQL*XL: addin for Excel for easy access to Oracle databases http://www.oraxcel.com "Daniel A. Morgan" <dmorgan_at_exesolutions.com> wrote in message news:3B454EB0.51839D90_at_exesolutions.com...Received on Sun Jul 08 2001 - 18:42:40 CEST
> Brian Janko wrote:
>
> > How can I get the results of several SQLPlus queries to Oracle to write
> > their results into a single tab-delimited text file?
> >
> > Thanks,
> > Brian
>
> Look at the built-in UTL_FILE package.
>
> Daniel A. Morgan
>