Re: Oracle Newbie Question

From: Mike Mountjoy <michael_at_london.virgin.net>
Date: Thu, 10 Dec 1998 10:29:59 -0000
Message-ID: <74o7ql$6mb$1@nclient3-gui.server.virgin.net>

you could use

set heading off

spool <file_name>

select a||','||b
from table x;

spool off

"Marx, Robert" wrote in message ...
>Is there any way to dump a table in Oracle 7.3 to a
>flat file...in much the same way that the bcp utility
>can be used in Sybase and SQL Server.
>
>I would have thought that SQL Loader would allow
>something like this.
>
>Any help in greatly appreciate.
>
>Thank you,
>
>
>
> -**** Posted from remarQ, Discussions Start Here(tm) ****-
>http://www.remarq.com/ - Host to the the World's Discussions & Usenet
Received on Thu Dec 10 1998 - 04:29:59 CST