|
 |
|
|
|
|
|
|
|
A.
External tables can be used to load flat files into the database.
Steps:
First create a directory say ext_dir and place the flat file (file.csv) in it and grant read/write access to it.
Then create the table as below:
create table erp_ext_table (
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;
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|