How to import a CSV file into SQL Developer

Title:

How to import a CSV file into SQL Developer?

Loading Data into a Table

Procedure:

After create a connection to the database in SQL Developer.

1. Right click on tables folder and Choose Import data.

tbl01
2 .Select xls.
tbl02
3. Follow the wizard
    - Provide table name
    - Select columns
    - Define datatype per column and provide the length
    - Finish.
tbl03
← Back to Home

Comments

Post a Comment