Re: HowTo unload an ORACLE table to an ASCII-file

What's wrong with using a database package that uses UTL_FILE to write your select statement to a file ?

--
Regards

Jason
*-------------------------------------------------*
| Jason Pepper          jpepper_at_steamer.u-net.com |
|                                                 |
|   ... look out Bill, the Penguin is coming      |
|                                                 |
*-------------------------------------------------*

Mark A. Porter wrote:

> "Ronald Göggel" wrote:


> >

> > Hi,

> >

> > I want to unload the contents of a table to an ASCII-file


> > with the fields separated by ']'.


>
> I do this:
> set linesize 1000;              /* must be able to hold longest line */
> set trimspool on;               /* trim trailing blanks */
> set heading off;                /* suppress column headings */
> set pagesize 0;                 /* suppress page breaks */
> set colsep ']'                  /* your desired column separator */
> spool filename;
> select * from tablename;
> spool off;
>


> >

> > 2nd question: is there a ORACLE FAQ? I didn't find any in these oracle

> > groups?

> >

> > Thank you for your help

> >

> > Ronald