Syntax Error while Creating Partition with MOD Function
Hi,
I am trying to create a MOD Based Partition table, but getting a syntax error. Can someone help me ?
CREATE TABLE PAR_MODU
(
A1 NUMBER (22) NOT NULL,
B1 NUMBER (22) NOT NULL
)
PARTITION BY RANGE (MOD(A1,10)
(PARTITION P1 VALUES LESS THAN 1));
1