EMPLOYEE_TBL

CREATE TABLE EMPLOYEE_TBL
{
EMP_ID              VARCHAR2(9)       NOT NULL,
LAST_NAME           VARCHAR2(15)      NOT NULL,
FIRST_NAME          VARCHAR2(15)      NOT NULL,
MIDDLE_NAME         VARCHAR2(15),
ADDRESS             VARCHAR2(30)      NOT NULL,
CITY                VARCHAR2(15)      NOT NULL,
STATE               CHAR(2)           NOT NULL,
ZIP                 NUMBER(5)         NOT NULL,
PHONE               CHAR(10),
PAGER               CHAR(10),
CONSTRAINT EMP_PK PRIMARY KEY (EMP_ID) REFERENCES EMPLOYEE_TBL (EMP_ID)
}
/

Get Sams Teach Yourself SQL in 24 Hours, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.