Overview

Oracle can import CSV file in the database in 3 ways:

  1. Use external tool (Oracle SQL Developer, DataGrip, etc)
  2. Use external table to create internal table
  3. 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