定义数组类型

CREATE OR REPLACE TYPE SCOTT.EMP_LINE AS OBJECT (

    EMPNO NUMBER(4) , ENAME VARCHAR2(20) );  

 

CREATE OR REPLACE TYPE SCOTT.EMP_ARRAY AS TABLE OF EMP_LINE;