Overview
Oracle can import CSV file in the database in 3 ways:
- Use external tool (Oracle SQL Developer, DataGrip, etc)
- Use external table to create internal table
- Use SQL Loader to insert into existing table.
So let's start with the second option.
Configuration
Let's firstly check our data:
Data Example