CREATE TABLE sample_regional_sales
(deptno number, item_no varchar2(20),
txn_date date, txn_amount number, state varchar2(2))
PARTITION BY RANGE (txn_date) SUBPARTITION BY LIST (state)
subpartition template
(SUBPARTITION nothwest values('OR', 'WA'),
SUBPARTITION sourthwest values('AZ', 'UT', 'NM'),
SUBPARTITION northeast values('NY', 'VM', 'NJ'),
SUBPARTITION southeast values('FL', 'GA'),
SUBPARTITION others values(default))
(PARTITION q1_1999 VALUES LESS THAN (TO_DATE('1-APR-1999','DD-MON-YYYY')) tablespace users,
PARTITION q2_1999 VALUES LESS THAN (TO_DATE('1-JUL-1999','DD-MON-YYYY')) tablespace users,
PARTITION q3_1999 VALUES LESS THAN (TO_DATE('1-OCT-1999','DD-MON-YYYY')) tablespace users,
PARTITION q4_1999 VALUES LESS THAN ( TO_DATE('1-JAN-2000','DD-MON-YYYY')) tablespace users
);
export PS1='$ORACLE_SID [`whoami`@$PWD ]\$ '