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_at_news.megsinet.net>#1/1
SPOOL [drive]:\path\filename
Add columns as needed and you can delimit your data with characters other than commas.
Date: 1997/12/02
Message-ID: <662j7f$ehr$1_at_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 CET