Convert flat file to Oracle table

Asked By Zachary Cashh -10 points N/A Posted on - 10/07/2013

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

• Status: Open
• Question Views: 962
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: ActionScript

Best Answer by

Go To Solution

Answered By Quinn Poon 0 points N/A #198753

Convert flat file to Oracle table

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

About Quinn Poon

Questions
0

Answers
30

Best Answers
1

• Vote Up 0 Vote Down

• Posted on - 10/07/2013
• Question Category: ActionScript

Best Answer

Best Answer

Answered By points N/A #148193

Convert flat file to Oracle table

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.

About

Questions
0

Answers
6

Best Answers
31531

• Vote Up 0 Vote Down

• Posted on - 11/05/2013
• Question Category: ActionScript