Re: Is there BCP like utility for Oracle (to unload data to text file)

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.