Display the structure of a table with a valarray column : VARRAY Column « Collections « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. Collections
3. VARRAY Column

SQL>
SQL> CREATE Or Replace TYPE addressVarray AS VARRAY(2) OF VARCHAR2(50);
  2  /

Type created.

SQL> CREATE TABLE employee (
  2    id         INTEGER PRIMARY KEY,
  3    first_name VARCHAR2(10),
  4    last_name  VARCHAR2(10),
  5    addresses  addressVarray
  6  );

Table created.

SQL>
SQL> DESCRIBE employee
 Name         Null?    Type
-------------------------------------
 ID           NOT NULL NUMBER(38)
 FIRST_NAME            VARCHAR2(10)
 LAST_NAME             VARCHAR2(10)
 ADDRESSES             ADDRESSVARRAY

SQL>
SQL> drop table employee;

Table dropped.

SQL>
SQL>