CREATE TABLE sales_range (salesman_idNUMBER(5), salesman_name VARCHAR2(30), sales_amountNUMBER(10), sales_date
DATE)PARTITION BY RANGE(sales_date) (PARTITION sales_jan2000 VALUES LESS THAN(TO_DATE('02/01/2000','DD/MM/YYYY')),PARTITION sales_feb2000 VALUES LESS THAN(TO_DATE('03/01/2000','DD/MM/YYYY')),PAR...
|