2 Replies Latest reply: Sep 13, 2011 3:02 AM by wkobargs-Oracle RSS

    updating the table data wit the csv data

      For the first time i used this to load data into oracle table. But every month the load is to happen from the csv. Is there any way where i can directly insert the data into the already existing table.
      create table ext_table_csv (
      i Number,
      n Varchar2(20),
      m Varchar2(20)
      organization external (
      type oracle_loader
      default directory ext_dir
      access parameters (
      records delimited by newline
      fields terminated by ','
      missing field values are null
      location ('file.csv')
      reject limit unlimited;