Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Object Oriented

 

Drop a type

SQL> SQL> create or replace type address_type as object   2    ( city    varchar2(30),   3      street  varchar2(30),   4      state   varchar2(2),   5      zip     number   6    )   7  / Type created. SQL> SQL> drop type address_type; Type dropped.