Re: HowTo unload an ORACLE table to an ASCII-file
From: Mark A. Porter <maporter_at_ix.netcom.com>
Date: Sat, 19 Dec 1998 02:17:19 -0600
Message-ID: <367B610F.BC4153E7_at_ix.netcom.com>
select * from tablename;
spool off;
Date: Sat, 19 Dec 1998 02:17:19 -0600
Message-ID: <367B610F.BC4153E7_at_ix.netcom.com>
"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
Received on Sat Dec 19 1998 - 09:17:19 CET