create table employee(
empno integer,
ename varchar(20),
esal
)
unique primary index(empno,empsal)
partition by case_n(
empsal<10000,
empsal<20000,
empsal<30000,
NOCASE,
Unknown
);
YESSSSSSSSSSSSSSSSSSSSSS . Now partition is created using empsal
which is part of UPI
No comments:
Post a Comment