How can i load nested table data through sql*loader?
any exmaples
Printable View
How can i load nested table data through sql*loader?
any exmaples
Hi,
you can use the COLUMN OBJECT parameter in control file to indicate an object is loaded.
example:
create type NAME_TYPE
as object
(
first_name varchar2(20),
last_name varchar2(20)
);
/
create table EMP
(
EMPNO number,
ENAME NAME_TYPE
);
sqllodr control file:
LOAD DATA
INFILE *
INTO TABLE EMP
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
( EMPNO ,
ENAME column object
(first_name char,
last_name char)
)
BEGINDATA
1, A1, B1
1, A2, B2
3, A3, B3
Cheers.