Oracle分区表类型用法(二)
(500))
partitionbyrange(arrange_id)subpartitionbylist(list_info)
(
partition part1 valueslessthan(100)
(subpartition part11 values('car'),
subpartition part12 values(default)
),
partition part2 valueslessthan(200)
);
插入数据
insertinto compound values(50,'car');
insertinto compound values(60,'books');
查找数据
select *from compound partition(part1)
select *from compound subpartition(part11)