Re: ASCII Data Export

Brenda Muller wrote:
>
> 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"

You can spool LONG datatype also from SQL*PLUS. SET LONG 3000

-- 
  AMARENDRA B NETTEM ( http://www.iit.edu/~nettama)
  ORACLE CONSULTANT
  WHITTMAN-HART CORPORATION
  CHICAGO.