Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Collections

 

CREATE TABLE with a VARRAY

SQL> SQL> CREATE OR REPLACE TYPE mem_type IS VARRAY(10) of VARCHAR2(15)   2  / SQL> SQL> CREATE TABLE club (Name VARCHAR2(10),   2  Address VARCHAR2(20),   3  City VARCHAR2(20),   4  Phone VARCHAR2(8),   5  Members mem_type)   6  / SQL> SQL> DESC club;  Name                                                                                                                                                                  Null?    Type  -----------  NAME                                                                                                                                                                           VARCHAR2(10)  ADDRESS                                                                                                                                                                        VARCHAR2(20)  CITY                                                                                                                                                                           VARCHAR2(20)  PHONE                                                                                                                                                                          VARCHAR2(8)  MEMBERS                                                                                                                                                                        MEM_TYPE SQL> SQL> drop table club; Table dropped. SQL> drop type mem_type; Type dropped. SQL>