| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: dump to CSV (comma-separated values) file format
thank you all - we are still in the traditional way (9i).
SQL-generate-SQL is what I want now.
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Kevin Closson
Sent: Thursday, October 19, 2006 1:14 PM
To: Stefan Knecht
Cc: oracle-l
Subject: RE: dump to CSV (comma-separated values) file format
Yeah, the "traditional" (9i) way of external tables is still there in 10g. It depends what access driver you're using to access the table. If you're using sql*loader, you can read from a flat file. If you're using the new datapump driver (which support writing , but afaik no dml) you can write to the file. But then it's a binary file.
nice..thanks for the info guys (and for not RTFMing me :-) )
Kevin Closson
Blogging at kevinclosson.wordpress.com
--
http://www.freelists.org/webpage/oracle-l
This e-mail is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Any review, dissemination, copying, printing or other use o
 |
 |