作业5

Execise05
1.创建一个名为Stock_Received表，其中包括Stock_ID、Stock_Date、Cost列。根据Stock_Date列为该表创建3个范围分区，然后根据Cost将表分为8个散列分区，共创建24个子分区.

1.
create table stock_received
 (
   stock_id  number(4) not null primary key,
   stock_date varchar2(30),
   cost number(5)
 )
partition by range(stock_date)
subpartition by hash(cost)
SUBPARTITIONS 8
(
  partition p1 VALUES  less than(to_date('01/4月/2010','dd/mon/yyyy')),
  partition p2 values less than(to_date('01/9月/2010','dd/mon/yyyy')),
  partition p3 values less than(maxvalue)
);