How to load into nested table by SQL*Loader?

From: Je Won Yeon <jwyeon_at_comeng.chungnam.ac.kr>
Date: Tue, 15 Sep 1998 11:00:17 +0900
Message-ID: <6tkhg1$ksm$1@news.chungnam.ac.kr>

I want use SQL*Loader to insert data,
and
i defined some table in nested table.

Is it possible to load SQL*Loader( Oracle Enterprise 8 version ) into nested table?

and how to describe that? ( control file, data file )

---

ex> this is my table definition

CREATE TYPE O_Attribute AS OBJECT (
AttributeName VARCHAR2(100),
AttributeValue VARCHAR2(100)
);

CREATE TYPE Attributes AS TABLE OF O_Attribute;

CREATE TABLE NT_00000 (

   DocID           NUMBER(7),
   TypeID          NUMBER(3),

   Attribute_List Attributes
)
NESTED TABLE Attribute_List STORE AS AT_play;

=> I want to insert into nt_00000 by SQL*Loader!!!

---

thanks. Received on Mon Sep 14 1998 - 21:00:17 CDT