posted 21 years ago
hi,
please check my code.
CREATE OR REPLACE TYPE MYEMPARRAY AS OPBJECT
(
EMPID NUMBER(5),
FIRSTNAME VARCHAR2(10),
LASTNAME VARCHAR2(10),
SALARY NUMBER(6)
);
CREATE OR REPLACE TYPE EMPARRAY is VARRAY(20) OF MYEMPARRAY;
Now anybody can tell me how to enter values to MYEMPARRAY object and how to retrieve values from that?
thanx a lot.