Re: Is there BCP like utility for Oracle (to unload data to text file)
From: AMARENDRA B NETTEM <nettama_at_charlie.cns.iit.edu>
Date: 1997/12/02
Message-ID: <34843DC3.60A3_at_charlie.cns.iit.edu>#1/1
Date: 1997/12/02
Message-ID: <34843DC3.60A3_at_charlie.cns.iit.edu>#1/1
Sergei Didur wrote:
>
> I know that SQL Loader could load data from text file, but
> I'd like to unload data from Oracle DB to text file.
> Is it possible ???
Hi,
Use SPOOL command to create a text file.
SET LINESIZE 100
SET PAGESIZE 40
SET FEEDBACK OFF
SET HEADING OFF
SPOOL emp.dat
select * from emp;
SPOOL OFF
Hope This Helps
AMARENDRA
-- ****************************************************************************** AMARENDRA B NETTEM 5039 N E River Road, Apt. 1A Oracle Certified DBA (OCP) NORRIDGE, IL 60656 Whittman-Hart Inc., 311 South Wacker Drive, Suite 3500 Chicago, IL 60606. Ph.No. (708) 583 9870 (H) (312) 913 6758 (W) E-mail:nettama_at_charlie.cns.iit.edu, anettem_at_whittman-hart.com Homepage: http://www.iit.edu/~nettama **************************************************************************** Opinions are mine and do not necessarily reflect those of Whittman-hart Inc.Received on Tue Dec 02 1997 - 00:00:00 CET