create directory ext_temp_data as 'E:\work\'
create table slcu_200610 (
client_code varchar2(10),
course_code varchar2(100),
coruse_year varchar2(10),
course_sq_no varchar2(10),
course_name varchar2(100),
name varchar2(30),
user_id varchar2(30)
)
organization external (
type oracle_loader
default directory ext_temp_data
access parameters( fields terminated by ',')
location ('temp_200610_temp.csv')
)
reject limit unlimited