Load a text file that delimiter commas divide each field into Oracle database by using PL/SQL.
Prepare a text file with commas,
Go to text import
Open file that was created before, and set field count to 4 columns, and then import only 2 lines.
After finishing scoping each field by start and ending parameters, preview is able to display as below:
Go to Data to Oracle tab, get each field associated with the columns name. click import to load data without fails
No comments:
Post a Comment