
Inserting Rows in an Object Table
DECLARE
emp EMPLOYEE_TYP;
BEGIN
INSERT INTO employee_tab
VALUES (Employee_typ(310,'Evers','Boston','EBOSTON','555.111.2222',
'01-AUG-04','SA_REP',9000,.15,101,110,Address_typ('123 Main','San Francisco','CA','94111')));
INSERT INTO employee_tab
VALUES (Employee_typ(320,'Martha','Dunn','MDUNN','555.111.3333',
'30-SEP-04','AC_MGR',12500,0,101,110,Address_typ('123 Broadway','Redwood City','CA','94065')));
END;
/

0 comments:
Post a Comment