Discussion:
Q: Recall that you created this table for Global Globe's employees:
CREATE TABLE EMPLOYEE
(EMPLOYEE_ID NUMBER(10),
JOB_TITLE VARCHAR2(45),
first_name varchar2(40),
Last_name varchar2(40),
phone_number Varchar2(20));
Start with this CREATE TABLE command, and modify it to create a new range_partitioned table named CH07EMPLOYEE_RANGE that contains the same column as the employee table. The partition key is the EMPLOYEE_ID column, and there should be four partitions, all located in the USERS tablespace. Assume that the values in EMPLOYEE_ID start at one, reach 100,000, and are distributed evenly.