Importing CSV file to Oracle

From: Tim Mavers <webview_at_hotmail.com>
Date: 11 May 2001 13:02:04 -0500
Message-ID: <3afc286e$0$16451$45beb828@newscene.com>

I am trying to figure out how to import a CSV file to a table in Oracle 8i.

I know I can use sqlldr, but this requires control file that describes the data to import. The problem I have is the format of this CSV is dynamic. Actually it's pretty static, except that the number of columns can change.

Is there a way I can just import a CSV file and have Oracle create the table (I supply the name) for me?

In MS SQL Server, I used DTS which was pretty straightforward. Is there something equivalent in Oracle? Received on Fri May 11 2001 - 13:02:04 CDT