Re: ASCII Data Export

Hi,

Thanks for the response. I forgot to mention one important detail. One of the datatypes that I'm dealing with is "long". I don't believe I can select it in it's entirety through sqlplus. Or can I? Is there someway to get the data out of the long column into a flat file in text format?

Thanks again!

Rich Woods wrote:
>
> Brenda Muller wrote:
> >
> > Hi,
> >
> > I just need to export some data from an Oracle DB into a flat file,
> > delimited by something or other (doesn't really matter). What's the
> > *best* way to do this (easiest, quickest)?
> >
> > This is an older version of Oracle... 7.0.13... running on HP-UX 9.1
> >
 

> Brenda,
>
> The quickest way is to use SQL*Plus. Between the various Set options
> and select list syntax, you can easily put together your dump utility.
> --
> Rich Woods
> Technical Field Support Specialist, Oracle Corporation, USA
> The above statements and opinions are my own and do not
> necessarily represent those of Oracle Corporation.
 

-- 
Brenda S. Muller
Sr. Consultant, Miaco Corporation / U S West

"Water yields, yet is able to wear down rocks and stone.
The gentle wears out the hard.  The easy outlasts the
difficult.  All people know this, yet few practice gentleness."

			- from "The Tao of Women"