Friday, January 28, 2011

Can this SQL be okay now?

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