Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Object Oriented

 

DELETE on whole Nested Tables

SQL> SQL> CREATE OR REPLACE TYPE numberTableType AS TABLE OF NUMBER(10);   2  / Type created. SQL> SQL> CREATE TABLE address_list (list_id VARCHAR2(6)PRIMARY KEY,   2                   home_addresses numberTableType )   3                   NESTED TABLE home_addresses STORE AS home_addreses_tab; SQL> SQL> INSERT INTO address_list VALUES('H101',numberTableType(1001,1002,1003,1004)); SQL> SQL> DELETE FROM address_list   2  WHERE list_id ='H102'; SQL> SQL> drop table address_list;