--嵌套表-------------------------------------------------------------------------------------------
XXT用户
DROP TABLE xxt_ogl_ctrl_req_b;
DROP TYPE xxt_prog_name_array;
DROP TYPE xxt_prog_name_type;

CREATE TYPE xxt_prog_name_type AS OBJECT (
  prog_name   VARCHAR2 (50)
);

CREATE TYPE xxt_prog_name_array AS TABLE OF xxt_prog_name_type;

CREATE  TABLE xxt_ogl_ctrl_req_b(    prog_id NUMBER,pre_prog_num     NUMBER,
    pre_prog_name xxt_prog_name_array,
    prog_short_name  VARCHAR2(50),                                                                --自己简称
    prog_desc        VARCHAR2(50),                                                                --自己描述
    p_parameter      VARCHAR2(20),                                                  --自己除了总控日期的参数
    prog_req_id      NUMBER                                                                     --自己请求ID
    )
    NESTED TABLE pre_prog_name STORE AS xxt_pre_prog_name;
--授权
grant all on XXT_OGL_CTRL_REQ_B to apps;
grant all on xxt_prog_name_array to apps;
grant all on xxt_prog_name_type to apps;
APPS用户
create synonym XXT_OGL_CTRL_REQ_B for xxt.XXT_OGL_CTRL_REQ_B;
create synonym xxt_prog_name_array for xxt.xxt_prog_name_array;
create synonym xxt_prog_name_type for xxt.xxt_prog_name_type;
访问：select * from the(select cr.pre_prog_name from XXT_OGL_CTRL_REQ_B cr where cr.prog_id  =5 )
--数组--------------------------------------------------------------------------------------------
XXT用户
DROP TABLE xxt_ogl_ctrl_req_b;
DROP TYPE xxt_prog_name_array;
DROP TYPE xxt_prog_name_type;

CREATE TYPE xxt_prog_name_type AS OBJECT (
  prog_name   VARCHAR2 (50)
);

CREATE TYPE xxt_prog_name_array AS VARRAY (50) OF xxt_prog_name_type;

CREATE  TABLE xxt_ogl_ctrl_req_b(    prog_id NUMBER,pre_prog_num     NUMBER,                      --前驱数目
    pre_prog_name xxt_prog_name_array,
    prog_short_name  VARCHAR2(50),                                                                --自己简称
    prog_desc        VARCHAR2(50),                                                                --自己描述
    p_parameter      VARCHAR2(20),                                                  --自己除了总控日期的参数
    prog_req_id      NUMBER                                                                     --自己请求ID
    );
--授权
grant all on XXT_OGL_CTRL_REQ_B to apps;
grant all on xxt_prog_name_array to apps;
grant all on xxt_prog_name_type to apps;
APPS用户
create synonym XXT_OGL_CTRL_REQ_B for xxt.XXT_OGL_CTRL_REQ_B;
create synonym xxt_prog_name_array for xxt.xxt_prog_name_array;
create synonym xxt_prog_name_type for xxt.xxt_prog_name_type;
访问：select * from the(select cr.pre_prog_name from XXT_OGL_CTRL_REQ_B cr where cr.prog_id  =5 )