Devart Forums

Code: Select all

create type t_selection_row as varray(200) of number(3);

create type t_selection_row_list as varray(200) of t_selection_row;

CREATE TABLE Sal_Coupon2 (
       Coupon_Id            VARCHAR2(20) NOT NULL,
       Batch_Prn            NUMBER(15) NULL,
       Selection_Area       t_selection_row_list,
       Active               CHAR(1) NULL
                                   CONSTRAINT y_n402
                                          CHECK (Active IN ('Y', 'N')),
       CONSTRAINT Sal_Coupon2XPK 
              PRIMARY KEY (Coupon_Id)
)
    organization index
;

insert into Sal_Coupon2 values ('ABC123',1,t_selection_row_list(t_selection_row(1,2,3,4,5,6,7),t_selection_row(28,29,30,31,32,33,34)),'Y');

commit;