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

From: Scott Niese <niese_at_stratos.net>
Date: 1997/12/02
Message-ID: <662j7f$ehr$1@news.megsinet.net>#1/1

Sergei Didur wrote in message <01bcfe96$6de8bcd0$79a06080_at_sdidur-1>...
>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 ???

Use SQL*Plus as follows:

---

SPOOL [drive]:\path\filename

SELECT COLUMN1 || "," || COLUMN2 || ","
FROM TABLE1; SPOOL OFF

---

Add columns as needed and you can delimit your data with characters other than commas.

Crystal Reports works great also but is more expensive than this solution :)

Hope this helps...
Scott Received on Tue Dec 02 1997 - 00:00:00 CST