Partition table syntaxes

create table part(a date)
PARTITION BY RANGE (a)
INTERVAL (NUMTOYMINTERVAL(1,'MONTH'))
(partition p1 values less than (TO_DATE('01-NOV-2007','DD-MON-YYYY')));

CREATE TABLE "KAJAL"."PRODUCTS"
( "PARTNO" NUMBER, "DESCRIPTION" VARCHAR2(60 BYTE) )
PARTITION BY HASH ("PARTNO")
(PARTITION "SYS_P21" TABLESPACE "USERS" ,
PARTITION "SYS_P22" TABLESPACE "USERS" ,
PARTITION "SYS_P23" TABLESPACE "USERS" ,
PARTITION "SYS_P24" TABLESPACE "USERS" ) ;

CREATE TABLE "KAJAL"."SALES"
( "YEAR" NUMBER(4,0),
"PRODUCT" VARCHAR2(10 BYTE),
"AMT" NUMBER(10,2))
PARTITION BY RANGE ("YEAR")
(PARTITION "P1" VALUES LESS THAN (1992) ,
PARTITION "P2" VALUES LESS THAN (1993) ,
PARTITION "P3" VALUES LESS THAN (1994) ,
PARTITION "P4" VALUES LESS THAN (1995) ,
PARTITION "P5" VALUES LESS THAN (MAXVALUE) ;