|
SQL>
SQL> CREATE OR REPLACE TYPE mem_type IS VARRAY(10) of VARCHAR2(15)
2 /
SQL>
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>
SQL>
|