First Semester Exam Q10

10
a
CREATE TABLE EMPLOYEES_3
(
EMPLOYEE_ID NUMBER (6,0) NOT NULL,
FIRST_NAME VARCHAR2 (20),
LAST_NAME VARCHAR2 (20) NOT NULL,
CONSTRAINT PK_EMPLOYEE_ID PRIMARY KEY (EMPLOYEE_ID)

)
--TO TEST a
SELECT COLUMN_NAME, DATA_TYPE, DATA_LENGTH, DATA_PRECISION, NULLABLE FROM USER_TAB_COLUMNS WHERE TABLE_NAME = 'EMPLOYEES_3'

b
DELETE FROM EMPLOYEES_3

c
CREATE SEQUENCE EMP_SEQ_01
START WITH 2010
MAXVALUE 2999
INCREMENT BY 2
NOCACHE

d
INSERT INTO EMPLOYEES_3
(EMPLOYEE_ID,FIRST_NAME,LAST_NAME)
VALUES
(EMP_SEQ_01.NEXTVAL, :FIRST_NAME, :LAST_NAME)

--TO TEST d
SELECT * FROM EMPLOYEES_3


Any comments?

A: CREATE TABLE employees3 AS SELECT employee_id, first_name, last_name FROM employees;

Yes your "a" is better.