Create table based on csv file with 'nobadfile' : CSV Table « Table « Oracle PL / SQL






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

Create table based on csv file with 'nobadfile'



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         nobadfile
 11         fields terminated by ',')
 12       location ('teacher.csv')
 13     )
 14     reject limit unlimited
 15     /

Table created.

SQL>
SQL>
SQL> drop table teachers_ext;

Table dropped.

SQL>








Related examples in the same category

1.Create table from external csv file
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