create table emp
(empno varchar(20) not null ,
empname varchar(20),
deptno int,
birthdate date not...null,
salary int
)
partition by range(year(birthdate))
(
partition p1 values less than (1980),...partition p2 values less than (1990),
partition p3 values less than maxvalue
);
以year(birthdate)表达式...create table emp
(empno varchar(20) not null ,
empname varchar(20),
deptno int,
birthdate date not...create table emp
(empno varchar(20) not null ,
empname varchar(20),
deptno int,
birthdate date