This discussion is archived
2 Replies Latest reply: Sep 13, 2011 1:02 AM by wkobargs RSS

updating the table data wit the csv data

885434 Newbie
Currently Being Moderated
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;

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points