You will also require to enlarge the pagesize parameter if your list is
long. You may also require to change the linesize parameter depending on
your requirement.
--
Tariq Ali Dawood Al-Raisi
tariq_at_omantel.net.om
Richard Gowan <roxl_at_ozemail.com.au> wrote in message
news:y23Y3.3230$MZ.24657_at_ozemail.com.au...
> > I'm a relative Oracle newbie and I need to out put the entire
> > contents of a table (some 200,000 records) into a delimited
> > ASCII text file.
> >
> > I'm using Oracle 7 on Solaris..
> >
> > How do I do it, I've looked through all the docs I have and can't
> > find anyway of doing this.
> >
> > rex..
>
> Conceptually - all you want to do is a
>
> SELECT col1 || ',' || col2 || ',' || col3 -- etc
> FROM tablename
>
> You need to spool this into a file using the SPOOL "name" and SPOOL OFF
> commands, and you will probably mess with SQL*Plus a bit to turn off the
> heading info (and maybe the pagesize also)
>
> SET HEADING OFF
>
> The script supplied by Conan appears to do all this automatically for a
> given table.
>
> Cheers,
>
> Richard Gowan
>
>
Received on Mon Nov 15 1999 - 20:32:22 CST