Live ORACLE

DECLARE
 emp  EMPLOYEE_TYP;
BEGIN
 INSERT INTO employee_tab
 VALUES     (Employee_typ(370,'Robert','Myers','RMYERS','555.111.2277',
                          '07-NOV-04','SA_REP',8800,.12,101,110,Address_typ('540 Fillmore','San Francisco','CA','94011')));
 UPDATE employee_tab e
 SET    e.address.street = '1040 California'
 WHERE  e.employee_id = 370;
 DELETE FROM employee_tab e
 WHERE       e.employee_id = 310;
END;
/  

Updating and Deleting Rows in an Object Table