Convert flat file to Oracle table

Asked By 0 points N/A Posted on -
qa-featured

Hello Guys,

I need to transfer the data in a text file separated by comma to oracle table using PL/SQL. Please advise me about, How to convert flat file to Oracle table.

Thanks,

Zachary Cashh

SHARE
Best Answer by RubyIslam3
Answered By 0 points N/A #198753

Convert flat file to Oracle table

qa-featured

Hello Zachary,

Good Day!

Oracle Database XE can copy data between itself and other Oracle databases, and between itself and external files. Data copying is accomplished by exporting and importing data, and by unloading and loading data.

For more information about the Oracle Database, just visit this link.

Hope I help you.

Regards,.

Quinn Poon

Best Answer
Best Answer
Answered By 70 points N/A #148193

Convert flat file to Oracle table

qa-featured

Hello,

You can use SQL Loader which is an Oracle built-in bulk loader utility for transferring data from flat files into Oracle Table.

First of all, you will have to create a table where your data will be exported. Then, create a data file with any type of extension, such as, .DAT or .CSV.

Next, you will have to create a control file with the extension .CTL. Then, load the data into the table.

Here, you will find more useful information for this process.

Login/Register to Answer

Related Questions