create table stud(
id int not null,
name varchar2(20),
ins_date DATE DEFAULT SYSDATE NOT NULL,
scroe int
)
PARTITION BY RANGE(to_days(ins_date))
(
partition p1 values less than(to_days('2010-01-01')),
partition p2 values less than(to_days('2011-01-01')),
partition p3 values less than(maxvalue)
);
错误在:
ERROR at line 5:
ORA-00907: missing right parenthesis
谁能帮帮我呀,非常感谢
id int not null,
name varchar2(20),
ins_date DATE DEFAULT SYSDATE NOT NULL,
scroe int
)
PARTITION BY RANGE(to_days(ins_date))
(
partition p1 values less than(to_days('2010-01-01')),
partition p2 values less than(to_days('2011-01-01')),
partition p3 values less than(maxvalue)
);
错误在:
ERROR at line 5:
ORA-00907: missing right parenthesis
谁能帮帮我呀,非常感谢
id int not null,
name varchar2(20),
ins_date DATE DEFAULT SYSDATE NOT NULL,
scroe int
)
PARTITION BY RANGE(ins_date)
(
partition p1 values less than(to_date('2010-01-01','YYYY-MM-DD')),
partition p2 values less than(to_date('2011-01-01','YYYY-MM-DD')),
partition p3 values less than(maxvalue)
);
id int not null,
name varchar2(20),
ins_date DATE DEFAULT SYSDATE NOT NULL,
scroe int
)
PARTITION BY RANGE(ins_date)
(
partition p1 values less than(to_date('2010-01-01','yyyy-mm-dd')),
partition p2 values less than(to_date('2011-01-01','yyyy-mm-dd')),
partition p3 values less than(maxvalue)
);