(Solved) : Echo Building Demo Tables Please Wait Drop Table Emp Cascade Constraints Drop Table Dept D Q26340008 . . . .

— echo Building demo tables. Please wait.
DROP TABLE EMP CASCADE CONSTRAINTS;
DROP TABLE DEPT;
DROP TABLE SALGRADE;
DROP TABLE Prod CASCADE CONSTRAINTS;
DROP TABLE Vend;

CREATE TABLE DEPT (
DEPTNO NUMBER(2) NOT NULL,
DNAME CHAR(14),
LOC CHAR(13),
CONSTRAINT DEPT_PRIMARY_KEY PRIMARY KEY (DEPTNO));

INSERT INTO DEPT VALUES (10,’ACCOUNTING’,’NEW YORK’);
INSERT INTO DEPT VALUES (20,’RESEARCH’,’DALLAS’);
INSERT INTO DEPT VALUES (30,’SALES’,’CHICAGO’);
INSERT INTO DEPT VALUES (40,’OPERATIONS’,’BOSTON’);

CREATE TABLE EMP (
EMPNO NUMBER(4) NOT NULL,
ENAME CHAR(10),
JOB CHAR(9),
MGR NUMBER(4) CONSTRAINT EMP_SELF_KEY
REFERENCES EMP (EMPNO),
HIREDATE DATE,
SAL NUMBER(7,2),
COMM NUMBER(7,2),
DEPTNO NUMBER(2) NOT NULL,
CONSTRAINT EMP_FOREIGN_KEY FOREIGN KEY (DEPTNO) REFERENCES DEPT(DEPTNO),
CONSTRAINT EMP_PRIM_KEY PRIMARY KEY (EMPNO));

INSERT INTO EMP VALUES(7839,’KING’,’PRESIDENT’,NULL,’17-NOV-1981′,5000,NULL,10);
INSERT INTO EMP VALUES(7698,’BLAKE’,’MANAGER’,7839,’1-MAY-1981′,2850,NULL,30);
INSERT INTO EMP VALUES(7782,’CLARK’,’MANAGER’,7839,’9-JUN-1981′,2450,NULL,10);
INSERT INTO EMP VALUES(7566,’JONES’,’MANAGER’,7839,’2-APR-1981′,2975,NULL,20);
INSERT INTO EMP VALUES(7654,’MARTIN’,’SALESMAN’,7698,’28-SEP-1981′,1250,1400,30);
INSERT INTO EMP VALUES(7499,’ALLEN’,’SALESMAN’,7698,’20-FEB-1981′,1600,300,30);
INSERT INTO EMP VALUES(7844,’TURNER’,’SALESMAN’,7698,’8-SEP-1981′,1500,0,30);
INSERT