I like to use Varray

From: sohn dae ho <hoya1_at_shinbiro.com>
Date: Tue, 24 Aug 1999 16:43:55 +0900
Message-ID: <7ptigu$971$1@hiline.shinbiro.com>

I'm using Oracle 8.15........
I'd like to insert and update by using Varray...

After creating table and type in this way i'd like to handle SUJU_JAEGO_ARRAY using PL/SQL!!!!

Please help me!!!!

/* *********************************************************** */

/* YARDMAP DB LAY OUT */

/* *********************************************************** */

drop table YARDDONG;
commit;
drop type SUJU_JAEGO_ARRAY;
commit;
drop type SUJU_JAEGO;
commit;
create or replace type SUJU_JAEGO as object
(

suju VARCHAR2( 2),
suryang NUMBER(5),
weight NUMBER(8)
);
/
create or replace type SUJU_JAEGO as object
(

suju VARCHAR2( 2),
suryang NUMBER(5),
weight NUMBER(8)
);
/
create or replace type SUJU_JAEGO_ARRAY AS varray(10) OF SUJU_JAEGO; /

create table YARDDONG
(

dong VARCHAR2( 2),
use VARCHAR2( 1),
save VARCHAR2( 1),
quantity NUMBER(5),
tweight NUMBER(9),
cnt NUMBER(2),
suju_jaego SUJU_JAEGO_ARRAY
);
commit;

create unique index YARDDONG_ind on YARDDONG(dong); commit; Received on Tue Aug 24 1999 - 02:43:55 CDT