oracle_import_csv_data

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.

Let's firstly check our data:

Data Example



  • oracle_import_csv_data.txt
  • Last modified: 2020/11/23 12:13
  • by andonovj