manully typing the partiton table script is a hard work

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 ]\$ '