Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Collections

 

Display the structure of a table with a valarray 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>