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.