create table tq84_part_intv_rng (
num number,
grp varchar2(1),
val number
)
partition by range (num) interval (100)
subpartition by list (grp)
subpartition template (
subpartition sub_part_a values ('A'),
subpartition sub_part_b values ('B'),
subpartition sub_part_c values ('C')
)
(
partition values less than ( 100 )
);
insert into tq84_part_intv_rng values (444, 'X', 42);