【SQL开源代码栏目提醒】:网学会员为广大网友收集整理了,22.7.sql,希望对大家有所帮助!
--虚拟列分区
CREATE TABLE staff(
employee_id number(6) not null,
first_name varchar2(30),
last_name varchar2(40) not null,
email varchar2(25),
phone_number varchar2(20),
hire_date date not null,
job_id varchar2(10) not null,
salary number(8,2),
commission_pct number(2,2),
manager_id number(6),
department_id number(4),
total_compensation as (salary *( 1+com
mission_pct))
)
PARTITION BY RANGE (total_compensation)
(
PARTITION p1 VALUES LESS THAN (50000),
PARTITION p2 VALUES LESS THAN (100000),
PARTITION p3 VALUES LESS THAN (150000),
PARTITION p4 VALUES LESS THAN (MAXVALUE)
);