Re: HowTo unload an ORACLE table to an ASCII-file
Date: Mon, 21 Dec 1998 14:59:26 GMT
Message-ID: <75lnod$6b0$1_at_nnrp1.dejanews.com>
- use Jared Still's sql*unloader package(i have a copy of it on my web page but am not sure its the latest).
- FAQ: www.orafaq.org
In article <367B610F.BC4153E7_at_ix.netcom.com>,
"Mark A. Porter" <maporter_at_ix.netcom.com> wrote:
>
>
> "Ronald G=F6ggel" 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
>
-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Dec 21 1998 - 15:59:26 CET