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
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
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.
