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)
}
/