Create table from external csv file : CSV Table « Table « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Table
  3. CSV Table

Create table from external csv file



SQL>       create table teachers_ext (
  2        first_name     varchar2(15),
  3        last_name      varchar2(15),
  4        phone_number   varchar2(12)
  5      )
  6      organization external (
  7        type oracle_loader
  8        default directory ext_data_files
  9        access parameters (
 10         fields terminated by ',')
 11       location ('teacher.csv')
 12     )
 13     reject limit unlimited;

Table created.

SQL>
SQL>








Related examples in the same category

1.Create table based on csv file with 'nobadfile'
2.Create table for csv file with badfile option
3.Grant all on directory then load the csv file
4.Use CSV file as External table