sql*loader issue

[sarovb]

How can i load nested table data through sql*loader?
any exmaples

[rotem_fo]

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.