{"id":132486,"date":"2018-02-20T23:50:30","date_gmt":"2018-02-20T23:50:30","guid":{"rendered":"https:\/\/writemyessayfree.com\/database-sql-developer-sql-statements"},"modified":"2017-08-16T07:02:06","modified_gmt":"2017-08-16T07:02:06","slug":"database-sql-developer-sql-statements","status":"publish","type":"post","link":"https:\/\/www.benedictsol.com\/blogs\/database-sql-developer-sql-statements\/","title":{"rendered":"Database: SQL developer; SQL statements"},"content":{"rendered":"
\n

Database: SQL developer; SQL statements
This assignment requires SQL developer. Please only attempt if you are very familiar with SQL Developer and specifically SQL Statements<\/p>\n

After logging into SQL developer, you must load the tables to do the assignment.<\/p>\n

There are 3 files associated with this assignment<\/p>\n

the first file is instruction with username and password for SQL developer<\/p>\n

the second file is the information for the tables for SQL developer<\/p>\n

the third file is the homework assignment.<\/p>\n

Drop table dept cascade constraints; Drop table emp cascade constraints; Drop table customer cascade constraints; Drop table product cascade constraints; Drop table ord cascade constraints; Drop table item cascade constraints; Drop table salgrade cascade constraints; Drop table bonus cascade constraints; Drop table price cascade constraints; Drop table dummy cascade constraints;
Purge RecycleBin;
CREATE TABLE DEPT ( DEPTNO NUMBER(2) NOT NULL, DNAME VARCHAR2(14), LOC VARCHAR2(13), CONSTRAINT DEPT_PRIMARY_KEY PRIMARY KEY (DEPTNO)); INSERT INTO DEPT VALUES (10,\u2019ACCOUNTING\u2019,\u2019NEW YORK\u2019); INSERT INTO DEPT VALUES (20,\u2019RESEARCH\u2019,\u2019DALLAS\u2019); INSERT INTO DEPT VALUES (30,\u2019SALES\u2019,\u2019CHICAGO\u2019); INSERT INTO DEPT VALUES (40,\u2019OPERATIONS\u2019,\u2019BOSTON\u2019);
CREATE TABLE EMP ( EMPNO NUMBER(4) NOT NULL, ENAME VARCHAR2(10), JOB VARCHAR2(9), MGR NUMBER(4) CONSTRAINT EMP_MGR_FK REFERENCES EMP (EMPNO), HIREDATE DATE, SAL NUMBER(7,2), COMM NUMBER(7,2), DEPTNO NUMBER(2) NOT NULL, CONSTRAINT EMP_DEPTNO_FK FOREIGN KEY (DEPTNO) REFERENCES DEPT (DEPTNO), CONSTRAINT EMP_EMPNO_PK PRIMARY KEY (EMPNO)); INSERT INTO EMP VALUES (7839,\u2019KING\u2019,\u2019PRESIDENT\u2019,NULL,TO_DATE(\u201917-NOV-2001\u2032,\u2019DD-MON-YYYY\u2019),15000,NULL,10); INSERT INTO EMP VALUES (7698,\u2019Blake\u2019,\u2019MANAGER\u2019,7839,TO_DATE(\u20181-MAY-2001\u2032,\u2019DD-MON-YYYY\u2019),6850,NULL,30); INSERT INTO EMP VALUES (7782,\u2019CLARK\u2019,\u2019MANAGER\u2019,7839,TO_DATE(\u20189-JUN-2001\u2032,\u2019DD-MON-YYYY\u2019),5450,NULL,10); INSERT INTO EMP VALUES (7566,\u2019Jones\u2019,\u2019MANAGER\u2019,7839,TO_DATE(\u20182-APR-2001\u2032,\u2019DD-MON-YYYY\u2019),5975,NULL,20); INSERT INTO EMP VALUES (7654,\u2019Martin\u2019,\u2019SALESMAN\u2019,7698,TO_DATE(\u201928-SEP-2001\u2032,\u2019DD-MON-YYYY\u2019),4250,27400,30); INSERT INTO EMP VALUES (7499,\u2019ALLEN\u2019,\u2019SALESMAN\u2019,7698,TO_DATE(\u201920-FEB-2001\u2032,\u2019DD-MON-YYYY\u2019),3600,16300,30); INSERT INTO EMP VALUES (7844,\u2019TURNER\u2019,\u2019SALESMAN\u2019,7698,TO_DATE(\u20188-SEP-2001\u2032,\u2019DD-MON-YYYY\u2019),3500,0,30); INSERT INTO EMP VALUES (7900,\u2019James\u2019,\u2019CLERK\u2019,7698,TO_DATE(\u20183-DEC-2001\u2032,\u2019DD-MON-YYYY\u2019),4950,NULL,30); INSERT INTO EMP VALUES (7521,\u2019WARD\u2019,\u2019SALESMAN\u2019,7698,TO_DATE(\u201922-FEB-2001\u2032,\u2019DD-MON-YYYY\u2019),3250,55500,30); INSERT INTO EMP VALUES (7902,\u2019ford\u2019,\u2019ANALYST\u2019,7566,TO_DATE(\u20183-DEC-2001\u2032,\u2019DD-MON-YYYY\u2019),6000,NULL,20); INSERT INTO EMP VALUES (7369,\u2019SMITH\u2019,\u2019CLERK\u2019,7902,TO_DATE(\u201917-DEC-2000\u2032,\u2019DD-MON-YYYY\u2019),3800,NULL,20); INSERT INTO EMP VALUES (7788,\u2019SCOTT\u2019,\u2019ANALYST\u2019,7566,TO_DATE(\u201909-DEC-2002\u2032,\u2019DD-MON-YYYY\u2019),6000,NULL,20); INSERT INTO EMP VALUES (7876,\u2019ADAMS\u2019,\u2019CLERK\u2019,7788,TO_DATE(\u201912-JAN-2003\u2032,\u2019DD-MON-YYYY\u2019),4100,NULL,20); INSERT INTO EMP VALUES (7934,\u2019MILLER\u2019,\u2019CLERK\u2019,7782,TO_DATE(\u201923-JAN-2002\u2032,\u2019DD-MON-YYYY\u2019),4300,NULL,10);
CREATE TABLE BONUS ( ENAME VARCHAR2(10), JOB VARCHAR2(9), SAL NUMBER, COMM NUMBER);
CREATE TABLE SALGRADE ( GRADE NUMBER, LOSAL NUMBER, HISAL NUMBER); INSERT INTO SALGRADE VALUES (1,700,1200); INSERT INTO SALGRADE VALUES (2,1201,1400); INSERT INTO SALGRADE VALUES (3,1401,2000); INSERT INTO SALGRADE VALUES (4,2001,3000); INSERT INTO SALGRADE VALUES (5,3001,9999);
CREATE TABLE DUMMY ( DUMMY NUMBER ); INSERT INTO DUMMY VALUES (0);
CREATE TABLE CUSTOMER ( CUSTID NUMBER (6) NOT NULL, NAME VARCHAR2 (45), ADDRESS VARCHAR2 (40), CITY VARCHAR2 (30), STATE VARCHAR2 (2), ZIP VARCHAR2 (9), AREA NUMBER (3), PHONE VARCHAR2 (9), REPID NUMBER (4) NOT NULL, CREDITLIMIT NUMBER (9,2), COMMENTS VARCHAR2 (256), CONSTRAINT CUSTOMER_CUSTID_PK PRIMARY KEY (CUSTID), CONSTRAINT CUSTOMER_CUSTID_CK CHECK (CUSTID > 0));
CREATE TABLE ORD ( ORDID NUMBER (4) NOT NULL, ORDERDATE DATE, COMMPLAN VARCHAR2 (1), CUSTID NUMBER (6) NOT NULL, SHIPDATE DATE, TOTAL NUMBER (8,2) CONSTRAINT ORD_TOTAL_CK CHECK (TOTAL >= 0), CONSTRAINT ORD_CUSTID_FK FOREIGN KEY (CUSTID) REFERENCES CUSTOMER (CUSTID), CONSTRAINT ORD_ORDID_PK PRIMARY KEY (ORDID));
CREATE TABLE ITEM ( ORDID NUMBER (4) NOT NULL, ITEMID NUMBER (4) NOT NULL, PRODID NUMBER (6), ACTUALPRICE NUMBER (8,2), QTY NUMBER (8), ITEMTOT NUMBER (8,2), CONSTRAINT ITEM_ORDID_FK FOREIGN KEY (ORDID) REFERENCES ORD (ORDID), CONSTRAINT ITEM_ORDID_ITEMID_PK PRIMARY KEY (ORDID,ITEMID));
CREATE TABLE PRODUCT ( PRODID NUMBER (6) CONSTRAINT PRODID_PK PRIMARY KEY, DESCRIP VARCHAR2 (30));
CREATE TABLE PRICE ( PRODID NUMBER (6) NOT NULL, STDPRICE NUMBER (8,2), MINPRICE NUMBER (8,2), STARTDATE DATE,
ENDDATE DATE);
INSERT INTO CUSTOMER (ZIP, STATE, REPID, PHONE, NAME, CUSTID, CREDITLIMIT, CITY, AREA, ADDRESS, COMMENTS) VALUES (\u201896711\u2019, \u2018CA\u2019, \u20187844\u2019, \u2018598-6609\u2019, \u2018JOCKSPORTS\u2019, \u2018100\u2019, \u20185000\u2019, \u2018BELMONT\u2019, \u2018415\u2019, \u2018345 VIEWRIDGE\u2019, \u2018Very friendly people to work with \u2014 sales rep likes to be called Mike.\u2019); INSERT INTO CUSTOMER (ZIP, STATE, REPID, PHONE, NAME, CUSTID, CREDITLIMIT, CITY, AREA, ADDRESS, COMMENTS) VALUES (\u201894061\u2019, \u2018CA\u2019, \u20187521\u2019, \u2018368-1223\u2019, \u2018TKB SPORT SHOP\u2019, \u2018101\u2019, \u201810000\u2019, \u2018REDWOOD CITY\u2019, \u2018415\u2019, \u2018490 BOLI RD.\u2019, \u2018Rep called 5\/8 about change in order \u2013 contact shipping.\u2019); INSERT INTO CUSTOMER (ZIP, STATE, REPID, PHONE, NAME, CUSTID, CREDITLIMIT, CITY, AREA, ADDRESS, COMMENTS) VALUES (\u201895133\u2019, \u2018CA\u2019, \u20187654\u2019, \u2018644-3341\u2019, \u2018VOLLYRITE\u2019, \u2018102\u2019, \u20187000\u2019, \u2018BURLINGAME\u2019, \u2018415\u2019, \u20189722 HAMILTON\u2019, \u2018Company doing heavy promotion beginning 10\/89. Prepare for large orders during winter.\u2019); INSERT INTO CUSTOMER (ZIP, STATE, REPID, PHONE, NAME, CUSTID, CREDITLIMIT, CITY, AREA, ADDRESS, COMMENTS) VALUES (\u201897544\u2019, \u2018CA\u2019, \u20187521\u2019, \u2018677-9312\u2019, \u2018JUST TENNIS\u2019, \u2018103\u2019, \u20183000\u2019, \u2018BURLINGAME\u2019, \u2018415\u2019, \u2018HILLVIEW MALL\u2019, \u2018Contact rep about new line of tennis rackets.\u2019); INSERT INTO CUSTOMER (ZIP, STATE, REPID, PHONE, NAME, CUSTID, CREDITLIMIT, CITY, AREA, ADDRESS, COMMENTS) VALUES (\u201893301\u2019, \u2018CA\u2019, \u20187499\u2019, \u2018996-2323\u2019, \u2018EVERY MOUNTAIN\u2019, \u2018104\u2019, \u201810000\u2019, \u2018CUPERTINO\u2019, \u2018408\u2019, \u2018574 SUYYYYY RD.\u2019, \u2018Customer with high market share (23%) due to aggressive advertising.\u2019); INSERT INTO CUSTOMER (ZIP, STATE, REPID, PHONE, NAME, CUSTID, CREDITLIMIT, CITY, AREA, ADDRESS, COMMENTS) VALUES (\u201891003\u2019, \u2018CA\u2019, \u20187844\u2019, \u2018376-9966\u2019, \u2018K + T SPORTS\u2019, \u2018105\u2019, \u20185000\u2019, \u2018SANTA CLARA\u2019, \u2018408\u2019, \u20183476 EL PASEO\u2019, \u2018Tends to order large amounts of merchandise at once. Accounting is considering raising their credit limit. Usually pays on time.\u2019); INSERT INTO CUSTOMER (ZIP, STATE, REPID, PHONE, NAME, CUSTID, CREDITLIMIT, CITY, AREA, ADDRESS, COMMENTS) VALUES (\u201894301\u2019, \u2018CA\u2019, \u20187521\u2019, \u2018364-9777\u2019, \u2018SHAPE UP\u2019, \u2018106\u2019, \u20186000\u2019, \u2018PALO ALTO\u2019, \u2018415\u2019, \u2018908 SEQUOIA\u2019, \u2018Support intensive. Orders small amounts (< 800) of merchandise at a time.\u2019); INSERT INTO CUSTOMER (ZIP, STATE, REPID, PHONE, NAME, CUSTID, CREDITLIMIT, CITY, AREA, ADDRESS, COMMENTS) VALUES (\u201893301\u2019, \u2018CA\u2019, \u20187499\u2019, \u2018967-4398\u2019, \u2018WOMENS SPORTS\u2019, \u2018107\u2019, \u201810000\u2019, \u2018SUNNYVALE\u2019, \u2018408\u2019, \u2018VALCO VILLAGE\u2019, \u2018First sporting goods store geared exclusively towards women. Unusual promotion al style and very willing to take chances towards new products!\u2019); INSERT INTO CUSTOMER (ZIP, STATE, REPID, PHONE, NAME, CUSTID, CREDITLIMIT, CITY, AREA, ADDRESS, COMMENTS) VALUES (\u201855649\u2019, \u2018MN\u2019, \u20187844\u2019, \u2018566-9123\u2019, \u2018NORTH WOODS HEALTH AND FITNESS SUPPLY CENTER\u2019, \u2018108\u2019, \u20188000\u2019, \u2018HIBBING\u2019, \u2018612\u2019, \u201998 LONE PINE WAY\u2019, \u201d); INSERT INTO ORD (TOTAL, SHIPDATE, ORDID, ORDERDATE, CUSTID, COMMPLAN) VALUES (\u2018101.4\u2032, TO_DATE(\u201908-JAN-2007\u2032,\u2019DD-MON-YYYY\u2019), \u2018610\u2019, TO_DATE(\u201907-JAN-2007\u2032,\u2019DD-MON-YYYY\u2019), \u2018101\u2019, \u2018A\u2019); INSERT INTO ORD (TOTAL, SHIPDATE, ORDID, ORDERDATE, CUSTID, COMMPLAN) VALUES (\u201945\u2019, TO_DATE(\u201911-JAN-2007\u2032,\u2019DD-MON-YYYY\u2019), \u2018611\u2019, TO_DATE(\u201911-JAN-2007\u2032,\u2019DD-MON-YYYY\u2019), \u2018102\u2019, \u2018B\u2019);
INSERT INTO ORD (TOTAL, SHIPDATE, ORDID, ORDERDATE, CUSTID, COMMPLAN) VALUES (\u20185860\u2032, TO_DATE(\u201920-JAN-2007\u2032,\u2019DD-MON-YYYY\u2019), \u2018612\u2019, TO_DATE(\u201915-JAN-2007\u2032,\u2019DD-MON-YYYY\u2019), \u2018104\u2019, \u2018C\u2019); INSERT INTO ORD (TOTAL, SHIPDATE, ORDID, ORDERDATE, CUSTID, COMMPLAN) VALUES (\u20182.4\u2032, TO_DATE(\u201930-MAY-2006\u2032,\u2019DD-MON-YYYY\u2019), \u2018601\u2019, TO_DATE(\u201901-MAY-2006\u2032,\u2019DD-MON-YYYY\u2019), \u2018106\u2019, \u2018A\u2019); INSERT INTO ORD (TOTAL, SHIPDATE, ORDID, ORDERDATE, CUSTID, COMMPLAN) VALUES (\u201956\u2019, TO_DATE(\u201920-JUN-2006\u2032,\u2019DD-MON-YYYY\u2019), \u2018602\u2019, TO_DATE(\u201905-JUN-2006\u2032,\u2019DD-MON-YYYY\u2019), \u2018102\u2019, \u2018B\u2019); INSERT INTO ORD (TOTAL, SHIPDATE, ORDID, ORDERDATE, CUSTID, COMMPLAN) VALUES (\u2018698\u2032, TO_DATE(\u201930-JUN-2006\u2032,\u2019DD-MON-YYYY\u2019), \u2018604\u2019, TO_DATE(\u201915-JUN-2006\u2032,\u2019DD-MON-YYYY\u2019), \u2018106\u2019, \u2018A\u2019); INSERT INTO ORD (TOTAL, SHIPDATE, ORDID, ORDERDATE, CUSTID, COMMPLAN) VALUES (\u20188324\u2032,TO_DATE( \u201930-JUL-2006\u2032,\u2019DD-MON-YYYY\u2019), \u2018605\u2019, TO_DATE(\u201914-JUL-2006\u2032,\u2019DD-MON-YYYY\u2019), \u2018106\u2019, \u2018A\u2019); INSERT INTO ORD (TOTAL, SHIPDATE, ORDID, ORDERDATE, CUSTID, COMMPLAN) VALUES (\u20183.4\u2032, TO_DATE(\u201930-JUL-2006\u2032,\u2019DD-MON-YYYY\u2019), \u2018606\u2019, TO_DATE(\u201914-JUL-2006\u2032,\u2019DD-MON-YYYY\u2019), \u2018100\u2019, \u2018A\u2019); INSERT INTO ORD (TOTAL, SHIPDATE, ORDID, ORDERDATE, CUSTID, COMMPLAN) VALUES (\u201897.5\u2032, TO_DATE(\u201915-AUG-2006\u2032,\u2019DD-MON-YYYY\u2019), \u2018609\u2019, TO_DATE(\u201901-AUG-2006\u2032,\u2019DD-MON-YYYY\u2019), \u2018100\u2019, \u2018B\u2019); INSERT INTO ORD (TOTAL, SHIPDATE, ORDID, ORDERDATE, CUSTID, COMMPLAN) VALUES (\u20185.6\u2032, TO_DATE(\u201918-JUL-2006\u2032,\u2019DD-MON-YYYY\u2019), \u2018607\u2019, TO_DATE(\u201918-JUL-2006\u2032,\u2019DD-MON-YYYY\u2019), \u2018104\u2019, \u2018C\u2019); INSERT INTO ORD (TOTAL, SHIPDATE, ORDID, ORDERDATE, CUSTID, COMMPLAN) VALUES (\u201835.2\u2032, TO_DATE(\u201925-JUL-2006\u2032,\u2019DD-MON-YYYY\u2019), \u2018608\u2019, TO_DATE(\u201925-JUL-2006\u2032,\u2019DD-MON-YYYY\u2019), \u2018104\u2019, \u2018C\u2019); INSERT INTO ORD (TOTAL, SHIPDATE, ORDID, ORDERDATE, CUSTID, COMMPLAN) VALUES (\u2018224\u2032, TO_DATE(\u201905-JUN-2006\u2032,\u2019DD-MON-YYYY\u2019), \u2018603\u2019, TO_DATE(\u201905-JUN-2006\u2032,\u2019DD-MON-YYYY\u2019), \u2018102\u2019, \u201d); INSERT INTO ORD (TOTAL, SHIPDATE, ORDID, ORDERDATE, CUSTID, COMMPLAN) VALUES (\u20184450\u2032, TO_DATE(\u201912-MAR-2007\u2032,\u2019DD-MON-YYYY\u2019), \u2018620\u2019, TO_DATE(\u201912-MAR-2007\u2032,\u2019DD-MON-YYYY\u2019), \u2018100\u2019, \u201d); INSERT INTO ORD (TOTAL, SHIPDATE, ORDID, ORDERDATE, CUSTID, COMMPLAN) VALUES (\u20186400\u2032, TO_DATE(\u201901-FEB-2007\u2032,\u2019DD-MON-YYYY\u2019), \u2018613\u2019, TO_DATE(\u201901-FEB-2007\u2032,\u2019DD-MON-YYYY\u2019), \u2018108\u2019, \u201d); INSERT INTO ORD (TOTAL, SHIPDATE, ORDID, ORDERDATE, CUSTID, COMMPLAN) VALUES (\u201823940\u2032, TO_DATE(\u201905-FEB-2007\u2032,\u2019DD-MON-YYYY\u2019), \u2018614\u2019, TO_DATE(\u201901-FEB-2007\u2032,\u2019DD-MON-YYYY\u2019), \u2018102\u2019, \u201d); INSERT INTO ORD (TOTAL, SHIPDATE, ORDID, ORDERDATE, CUSTID, COMMPLAN) VALUES (\u2018764\u2032, TO_DATE(\u201910-FEB-2007\u2032,\u2019DD-MON-YYYY\u2019), \u2018616\u2019, TO_DATE(\u201903-FEB-2007\u2032,\u2019DD-MON-YYYY\u2019), \u2018103\u2019, \u201d); INSERT INTO ORD (TOTAL, SHIPDATE, ORDID, ORDERDATE, CUSTID, COMMPLAN) VALUES (\u20181260\u2032, TO_DATE(\u201904-FEB-2007\u2032,\u2019DD-MON-YYYY\u2019), \u2018619\u2019, TO_DATE(\u201922-FEB-2007\u2032,\u2019DD-MON-YYYY\u2019), \u2018104\u2019, \u201d); INSERT INTO ORD (TOTAL, SHIPDATE, ORDID, ORDERDATE, CUSTID, COMMPLAN) VALUES (\u201846370\u2032, TO_DATE(\u201903-MAR-2007\u2032,\u2019DD-MON-YYYY\u2019), \u2018617\u2019, TO_DATE(\u201905-FEB-2007\u2032,\u2019DD-MON-YYYY\u2019), \u2018105\u2019, \u201d); INSERT INTO ORD (TOTAL, SHIPDATE, ORDID, ORDERDATE, CUSTID, COMMPLAN) VALUES (\u2018710\u2032, TO_DATE(\u201906-FEB-2007\u2032,\u2019DD-MON-YYYY\u2019), \u2018615\u2019, TO_DATE(\u201901-FEB-2007\u2032,\u2019DD-MON-YYYY\u2019), \u2018107\u2019, \u201d); INSERT INTO ORD (TOTAL, SHIPDATE, ORDID, ORDERDATE, CUSTID, COMMPLAN) VALUES (\u20183510.5\u2032, TO_DATE(\u201906-MAR-2007\u2032,\u2019DD-MON-YYYY\u2019), \u2018618\u2019, TO_DATE(\u201915-FEB-2007\u2032,\u2019DD-MON-YYYY\u2019), \u2018102\u2019, \u2018A\u2019); INSERT INTO ORD (TOTAL, SHIPDATE, ORDID, ORDERDATE, CUSTID, COMMPLAN) VALUES (\u2018730\u2032, TO_DATE(\u201901-JAN-2007\u2032,\u2019DD-MON-YYYY\u2019), \u2018621\u2019, TO_DATE(\u201915-MAR-2007\u2032,\u2019DD-MON-YYYY\u2019), \u2018100\u2019, \u2018A\u2019); INSERT INTO ITEM (QTY, PRODID, ORDID, ITEMTOT, ITEMID, ACTUALPRICE) VALUES (\u20181\u2019, \u2018100890\u2019, \u2018610\u2019, \u201958\u2019, \u20183\u2019, \u201958\u2019); INSERT INTO ITEM ( QTY , PRODID , ORDID , ITEMTOT , ITEMID , ACTUALPRICE) VALUES ( \u20181\u2019, \u2018100861\u2019, \u2018611\u2019, \u201945\u2019, \u20181\u2019, \u201945\u2019); INSERT INTO ITEM ( QTY , PRODID , ORDID , ITEMTOT , ITEMID , ACTUALPRICE) VALUES ( \u2018100\u2019, \u2018100860\u2019, \u2018612\u2019, \u20183000\u2019, \u20181\u2019, \u201930\u2019); INSERT INTO ITEM ( QTY , PRODID , ORDID , ITEMTOT , ITEMID , ACTUALPRICE)
VALUES ( \u20181\u2019, \u2018200376\u2019, \u2018601\u2019, \u20182.4\u2019, \u20181\u2019, \u20182.4\u2019); INSERT INTO ITEM ( QTY , PRODID , ORDID , ITEMTOT , ITEMID , ACTUALPRICE) VALUES ( \u201920\u2019, \u2018100870\u2019, \u2018602\u2019, \u201956\u2019, \u20181\u2019, \u20182.8\u2019); INSERT INTO ITEM ( QTY , PRODID , ORDID , ITEMTOT , ITEMID , ACTUALPRICE) VALUES ( \u20183\u2019, \u2018100890\u2019, \u2018604\u2019, \u2018174\u2019, \u20181\u2019, \u201958\u2019); INSERT INTO ITEM ( QTY , PRODID , ORDID , ITEMTOT , ITEMID , ACTUALPRICE) VALUES ( \u20182\u2019, \u2018100861\u2019, \u2018604\u2019, \u201984\u2019, \u20182\u2019, \u201942\u2019); INSERT INTO ITEM ( QTY , PRODID , ORDID , ITEMTOT , ITEMID , ACTUALPRICE) VALUES ( \u201910\u2019, \u2018100860\u2019, \u2018604\u2019, \u2018440\u2019, \u20183\u2019, \u201944\u2019); INSERT INTO ITEM ( QTY , PRODID , ORDID , ITEMTOT , ITEMID , ACTUALPRICE) VALUES ( \u20184\u2019, \u2018100860\u2019, \u2018603\u2019, \u2018224\u2019, \u20182\u2019, \u201956\u2019); INSERT INTO ITEM ( QTY , PRODID , ORDID , ITEMTOT , ITEMID , ACTUALPRICE) VALUES ( \u20181\u2019, \u2018100860\u2019, \u2018610\u2019, \u201935\u2019, \u20181\u2019, \u201935\u2019); INSERT INTO ITEM ( QTY , PRODID , ORDID , ITEMTOT , ITEMID , ACTUALPRICE) VALUES ( \u20183\u2019, \u2018100870\u2019, \u2018610\u2019, \u20188.4\u2019, \u20182\u2019, \u20182.8\u2019); INSERT INTO ITEM ( QTY , PRODID , ORDID , ITEMTOT , ITEMID , ACTUALPRICE) VALUES ( \u2018200\u2019, \u2018200376\u2019, \u2018613\u2019, \u2018440\u2019, \u20184\u2019, \u20182.2\u2019); INSERT INTO ITEM ( QTY , PRODID , ORDID , ITEMTOT , ITEMID , ACTUALPRICE) VALUES ( \u2018444\u2019, \u2018100860\u2019, \u2018614\u2019, \u201815540\u2019, \u20181\u2019, \u201935\u2019); INSERT INTO ITEM ( QTY , PRODID , ORDID , ITEMTOT , ITEMID , ACTUALPRICE) VALUES ( \u20181000\u2019, \u2018100870\u2019, \u2018614\u2019, \u20182800\u2019, \u20182\u2019, \u20182.8\u2019); INSERT INTO ITEM ( QTY , PRODID , ORDID , ITEMTOT , ITEMID , ACTUALPRICE) VALUES ( \u201920\u2019, \u2018100861\u2019, \u2018612\u2019, \u2018810\u2019, \u20182\u2019, \u201840.5\u2019); INSERT INTO ITEM ( QTY , PRODID , ORDID , ITEMTOT , ITEMID , ACTUALPRICE) VALUES (\u2018150\u2019, \u2018101863\u2019, \u2018612\u2019, \u20181500\u2019, \u20183\u2019, \u201910\u2019); INSERT INTO ITEM ( QTY , PRODID , ORDID , ITEMTOT , ITEMID , ACTUALPRICE) VALUES (\u201910\u2019, \u2018100860\u2019, \u2018620\u2019, \u2018350\u2019, \u20181\u2019, \u201935\u2019); INSERT INTO ITEM ( QTY , PRODID , ORDID , ITEMTOT , ITEMID , ACTUALPRICE) VALUES (\u20181000\u2019, \u2018200376\u2019, \u2018620\u2019, \u20182400\u2019, \u20182\u2019, \u20182.4\u2019); INSERT INTO ITEM ( QTY , PRODID , ORDID , ITEMTOT , ITEMID , ACTUALPRICE) VALUES (\u2018500\u2019, \u2018102130\u2019, \u2018620\u2019, \u20181700\u2019, \u20183\u2019, \u20183.4\u2019); INSERT INTO ITEM ( QTY , PRODID , ORDID , ITEMTOT , ITEMID , ACTUALPRICE) VALUES ( \u2018100\u2019, \u2018100871\u2019, \u2018613\u2019, \u2018560\u2019, \u20181\u2019, \u20185.6\u2019); INSERT INTO ITEM ( QTY , PRODID , ORDID , ITEMTOT , ITEMID , ACTUALPRICE) VALUES (\u2018200\u2019, \u2018101860\u2019, \u2018613\u2019, \u20184800\u2019, \u20182\u2019, \u201924\u2019); INSERT INTO ITEM ( QTY , PRODID , ORDID , ITEMTOT , ITEMID , ACTUALPRICE) VALUES (\u2018150\u2019, \u2018200380\u2019, \u2018613\u2019, \u2018600\u2019, \u20183\u2019, \u20184\u2019); INSERT INTO ITEM ( QTY , PRODID , ORDID , ITEMTOT , ITEMID , ACTUALPRICE) VALUES (\u2018100\u2019, \u2018102130\u2019, \u2018619\u2019, \u2018340\u2019, \u20183\u2019, \u20183.4\u2019); INSERT INTO ITEM ( QTY , PRODID , ORDID , ITEMTOT , ITEMID , ACTUALPRICE) VALUES (\u201950\u2019, \u2018100860\u2019, \u2018617\u2019, \u20181750\u2019, \u20181\u2019, \u201935\u2019); INSERT INTO ITEM ( QTY , PRODID , ORDID , ITEMTOT , ITEMID , ACTUALPRICE) VALUES (\u2018100\u2019, \u2018100861\u2019, \u2018617\u2019, \u20184500\u2019, \u20182\u2019, \u201945\u2019); INSERT INTO ITEM ( QTY , PRODID , ORDID , ITEMTOT , ITEMID , ACTUALPRICE) VALUES (\u20181000\u2019, \u2018100871\u2019, \u2018614\u2019, \u20185600\u2019, \u20183\u2019, \u20185.6\u2019); INSERT INTO ITEM ( QTY , PRODID , ORDID , ITEMTOT , ITEMID , ACTUALPRICE) VALUES (\u201910\u2019, \u2018100861\u2019, \u2018616\u2019, \u2018450\u2019, \u20181\u2019, \u201945\u2019); INSERT INTO ITEM ( QTY , PRODID , ORDID , ITEMTOT , ITEMID , ACTUALPRICE) VALUES (\u201950\u2019, \u2018100870\u2019, \u2018616\u2019, \u2018140\u2019, \u20182\u2019, \u20182.8\u2019); INSERT INTO ITEM ( QTY , PRODID , ORDID , ITEMTOT , ITEMID , ACTUALPRICE) VALUES (\u20182\u2019, \u2018100890\u2019, \u2018616\u2019, \u2018116\u2019, \u20183\u2019, \u201958\u2019); INSERT INTO ITEM ( QTY , PRODID , ORDID , ITEMTOT , ITEMID , ACTUALPRICE) VALUES (\u201910\u2019, \u2018102130\u2019, \u2018616\u2019, \u201934\u2019, \u20184\u2019, \u20183.4\u2019); INSERT INTO ITEM ( QTY , PRODID , ORDID , ITEMTOT , ITEMID , ACTUALPRICE) VALUES (\u201910\u2019, \u2018200376\u2019 , \u2018616\u2019, \u201924\u2019, \u20185\u2019, \u20182.4\u2019); INSERT INTO ITEM ( QTY , PRODID , ORDID , ITEMTOT , ITEMID , ACTUALPRICE) VALUES (\u2018100\u2019, \u2018200380\u2019, \u2018619\u2019, \u2018400\u2019, \u20181\u2019, \u20184\u2019); INSERT INTO ITEM ( QTY , PRODID , ORDID , ITEMTOT , ITEMID , ACTUALPRICE) VALUES (\u2018100\u2019, \u2018200376\u2019, \u2018619\u2019, \u2018240\u2019, \u20182\u2019, \u20182.4\u2019); INSERT INTO ITEM ( QTY , PRODID , ORDID , ITEMTOT , ITEMID , ACTUALPRICE) VALUES (\u20184\u2019, \u2018100861\u2019, \u2018615\u2019, \u2018180\u2019, \u20181\u2019, \u201945\u2019); INSERT INTO ITEM ( QTY , PRODID , ORDID , ITEMTOT , ITEMID , ACTUALPRICE) VALUES (\u20181\u2019, \u2018100871\u2019, \u2018607\u2019, \u20185.6\u2019, \u20181\u2019, \u20185.6\u2019); INSERT INTO ITEM ( QTY , PRODID , ORDID , ITEMTOT , ITEMID , ACTUALPRICE)
VALUES (\u2018100\u2019, \u2018100870\u2019, \u2018615\u2019, \u2018280\u2019, \u20182\u2019, \u20182.8\u2019); INSERT INTO ITEM ( QTY , PRODID , ORDID , ITEMTOT , ITEMID , ACTUALPRICE) VALUES (\u2018500\u2019, \u2018100870\u2019, \u2018617\u2019, \u20181400\u2019, \u20183\u2019, \u20182.8\u2019); INSERT INTO ITEM ( QTY , PRODID , ORDID , ITEMTOT , ITEMID , ACTUALPRICE) VALUES (\u2018500\u2019, \u2018100871\u2019, \u2018617\u2019, \u20182800\u2019, \u20184\u2019, \u20185.6\u2019); INSERT INTO ITEM ( QTY , PRODID , ORDID , ITEMTOT , ITEMID , ACTUALPRICE) VALUES (\u2018500\u2019, \u2018100890\u2019, \u2018617\u2019, \u201829000\u2019, \u20185\u2019, \u201958\u2019); INSERT INTO ITEM ( QTY , PRODID , ORDID , ITEMTOT , ITEMID , ACTUALPRICE) VALUES (\u2018100\u2019, \u2018101860\u2019, \u2018617\u2019, \u20182400\u2019, \u20186\u2019, \u201924\u2019); INSERT INTO ITEM ( QTY , PRODID , ORDID , ITEMTOT , ITEMID , ACTUALPRICE) VALUES (\u2018200\u2019, \u2018101863\u2019, \u2018617\u2019, \u20182500\u2019, \u20187\u2019, \u201812.5\u2019); INSERT INTO ITEM ( QTY , PRODID , ORDID , ITEMTOT , ITEMID , ACTUALPRICE) VALUES (\u2018100\u2019, \u2018102130\u2019, \u2018617\u2019, \u2018340\u2019, \u20188\u2019, \u20183.4\u2019); INSERT INTO ITEM ( QTY , PRODID , ORDID , ITEMTOT , ITEMID , ACTUALPRICE) VALUES (\u2018200\u2019, \u2018200376\u2019, \u2018617\u2019, \u2018480\u2019, \u20189\u2019, \u20182.4\u2019); INSERT INTO ITEM ( QTY , PRODID , ORDID , ITEMTOT , ITEMID , ACTUALPRICE) VALUES (\u2018300\u2019, \u2018200380\u2019, \u2018617\u2019, \u20181200\u2019, \u201910\u2019, \u20184\u2019); INSERT INTO ITEM ( QTY , PRODID , ORDID , ITEMTOT , ITEMID , ACTUALPRICE) VALUES (\u20185\u2019, \u2018100870\u2019, \u2018609\u2019, \u201812.5\u2019, \u20182\u2019, \u20182.5\u2019); INSERT INTO ITEM ( QTY , PRODID , ORDID , ITEMTOT , ITEMID , ACTUALPRICE) VALUES (\u20181\u2019, \u2018100890\u2019, \u2018609\u2019, \u201950\u2019, \u20183\u2019, \u201950\u2019); INSERT INTO ITEM ( QTY , PRODID , ORDID , ITEMTOT , ITEMID , ACTUALPRICE) VALUES (\u201923\u2019, \u2018100860\u2019, \u2018618\u2019, \u2018805\u2019, \u20181\u2019, \u201935\u2019); INSERT INTO ITEM ( QTY , PRODID , ORDID , ITEMTOT , ITEMID , ACTUALPRICE) VALUES (\u201950\u2019, \u2018100861\u2019, \u2018618\u2019, \u20182255.5\u2019, \u20182\u2019, \u201845.11\u2019); INSERT INTO ITEM ( QTY , PRODID , ORDID , ITEMTOT , ITEMID , ACTUALPRICE) VALUES (\u201910\u2019, \u2018100870\u2019, \u2018618\u2019, \u2018450\u2019, \u20183\u2019, \u201945\u2019); INSERT INTO ITEM ( QTY , PRODID , ORDID , ITEMTOT , ITEMID , ACTUALPRICE) VALUES (\u201910\u2019, \u2018100861\u2019, \u2018621\u2019, \u2018450\u2019, \u20181\u2019, \u201945\u2019); INSERT INTO ITEM ( QTY , PRODID , ORDID , ITEMTOT , ITEMID , ACTUALPRICE) VALUES (\u2018100\u2019, \u2018100870\u2019, \u2018621\u2019, \u2018280\u2019, \u20182\u2019, \u20182.8\u2019); INSERT INTO ITEM ( QTY , PRODID , ORDID , ITEMTOT , ITEMID , ACTUALPRICE) VALUES (\u201950\u2019, \u2018100871\u2019, \u2018615\u2019, \u2018250\u2019, \u20183\u2019, \u20185\u2019); INSERT INTO ITEM ( QTY , PRODID , ORDID , ITEMTOT , ITEMID , ACTUALPRICE) VALUES (\u20181\u2019, \u2018101860\u2019, \u2018608\u2019, \u201924\u2019, \u20181\u2019, \u201924\u2019); INSERT INTO ITEM ( QTY , PRODID , ORDID , ITEMTOT , ITEMID , ACTUALPRICE) VALUES (\u20182\u2019, \u2018100871\u2019, \u2018608\u2019, \u201811.2\u2019, \u20182\u2019, \u20185.6\u2019); INSERT INTO ITEM ( QTY , PRODID , ORDID , ITEMTOT , ITEMID , ACTUALPRICE) VALUES (\u20181\u2019, \u2018100861\u2019, \u2018609\u2019, \u201935\u2019, \u20181\u2019, \u201935\u2019); INSERT INTO ITEM ( QTY , PRODID , ORDID , ITEMTOT , ITEMID , ACTUALPRICE) VALUES (\u20181\u2019, \u2018102130\u2019, \u2018606\u2019, \u20183.4\u2019, \u20181\u2019, \u20183.4\u2019); INSERT INTO ITEM ( QTY , PRODID , ORDID , ITEMTOT , ITEMID , ACTUALPRICE) VALUES (\u2018100\u2019, \u2018100861\u2019, \u2018605\u2019, \u20184500\u2019, \u20181\u2019, \u201945\u2019); INSERT INTO ITEM ( QTY , PRODID , ORDID , ITEMTOT , ITEMID , ACTUALPRICE) VALUES (\u2018500\u2019, \u2018100870\u2019, \u2018605\u2019, \u20181400\u2019, \u20182\u2019, \u20182.8\u2019); INSERT INTO ITEM ( QTY , PRODID , ORDID , ITEMTOT , ITEMID , ACTUALPRICE) VALUES (\u20185\u2019, \u2018100890\u2019, \u2018605\u2019, \u2018290\u2019, \u20183\u2019, \u201958\u2019); INSERT INTO ITEM ( QTY , PRODID , ORDID , ITEMTOT , ITEMID , ACTUALPRICE) VALUES (\u201950\u2019, \u2018101860\u2019, \u2018605\u2019, \u20181200\u2019, \u20184\u2019, \u201924\u2019); INSERT INTO ITEM ( QTY , PRODID , ORDID , ITEMTOT , ITEMID , ACTUALPRICE) VALUES (\u2018100\u2019, \u2018101863\u2019, \u2018605\u2019, \u2018900\u2019, \u20185\u2019, \u20189\u2019); INSERT INTO ITEM ( QTY , PRODID , ORDID , ITEMTOT , ITEMID , ACTUALPRICE) VALUES (\u201910\u2019, \u2018102130\u2019, \u2018605\u2019, \u201934\u2019, \u20186\u2019, \u20183.4\u2019); INSERT INTO ITEM ( QTY , PRODID , ORDID , ITEMTOT , ITEMID , ACTUALPRICE) VALUES (\u2018100\u2019, \u2018100871\u2019, \u2018612\u2019, \u2018550\u2019, \u20184\u2019, \u20185.5\u2019); INSERT INTO ITEM ( QTY , PRODID , ORDID , ITEMTOT , ITEMID , ACTUALPRICE) VALUES (\u201950\u2019, \u2018100871\u2019, \u2018619\u2019, \u2018280\u2019, \u20184\u2019, \u20185.6\u2019); INSERT INTO PRICE (STDPRICE, STARTDATE, PRODID, MINPRICE, ENDDATE) VALUES (\u20184.8\u2032, TO_DATE(\u201901-JAN-2005\u2032,\u2019DD-MON-YYYY\u2019), \u2018100871\u2019, \u20183.2\u2019, TO_DATE(\u201901-DEC-2006\u2032,\u2019DD-MON-YYYY\u2019));
INSERT INTO PRICE (STDPRICE, STARTDATE, PRODID, MINPRICE, ENDDATE) VALUES (\u201954\u2019, TO_DATE(\u201901-JUN-2005\u2032,\u2019DD-MON-YYYY\u2019), \u2018100890\u2019, \u201840.5\u2019, TO_DATE(\u201931-JUL-2006\u2032,\u2019DD-MON-YYYY\u2019));
INSERT INTO PRICE (STDPRICE, STARTDATE, PRODID, MINPRICE, ENDDATE) VALUES (\u201958\u2019, TO_DATE(\u201901-AUG-2007\u2032,\u2019DD-MON-YYYY\u2019), \u2018100890\u2019, \u201846.4\u2019, \u201d);
INSERT INTO PRICE (STDPRICE, STARTDATE, PRODID, MINPRICE, ENDDATE) VALUES (\u201930\u2019, TO_DATE(\u201901-JAN-2005\u2032,\u2019DD-MON-YYYY\u2019), \u2018100860\u2019, \u201924\u2019, TO_DATE(\u201931-DEC-2006\u2032,\u2019DD-MON-YYYY\u2019)); INSERT INTO PRICE (STDPRICE, STARTDATE, PRODID, MINPRICE, ENDDATE) VALUES (\u201932\u2019, TO_DATE(\u201901-JAN-2007\u2032,\u2019DD-MON-YYYY\u2019), \u2018100860\u2019, \u201825.6\u2019, TO_DATE(\u201931-MAY-2008\u2032,\u2019DD-MON-YYYY\u2019)); INSERT INTO PRICE (STDPRICE, STARTDATE, PRODID, MINPRICE, ENDDATE) VALUES (\u201935\u2019, TO_DATE(\u201901-JUN-2008\u2032,\u2019DD-MON-YYYY\u2019), \u2018100860\u2019, \u201928\u2019, \u201d);
INSERT INTO PRICE (STDPRICE, STARTDATE, PRODID, MINPRICE, ENDDATE) VALUES (\u201945\u2019, TO_DATE(\u201901-JUN-2006\u2032,\u2019DD-MON-YYYY\u2019), \u2018100861\u2019, \u201936\u2019, \u201d); INSERT INTO PRICE (STDPRICE, STARTDATE, PRODID, MINPRICE, ENDDATE) VALUES (\u201942\u2019, TO_DATE(\u201901-JAN-2006\u2032,\u2019DD-MON-YYYY\u2019), \u2018100861\u2019, \u201833.6\u2019, TO_DATE(\u201931-MAY-2006\u2032,\u2019DD-MON-YYYY\u2019)); INSERT INTO PRICE (STDPRICE, STARTDATE, PRODID, MINPRICE, ENDDATE) VALUES (\u201939\u2019, TO_DATE(\u201901-JAN-2005\u2032,\u2019DD-MON-YYYY\u2019), \u2018100861\u2019, \u201831.2\u2019, TO_DATE(\u201931-DEC-2005\u2032,\u2019DD-MON-YYYY\u2019)); INSERT INTO PRICE (STDPRICE, STARTDATE, PRODID, MINPRICE, ENDDATE) VALUES (\u20182.8\u2032, TO_DATE(\u201901-JAN-2006\u2032,\u2019DD-MON-YYYY\u2019), \u2018100870\u2019, \u20182.4\u2019, \u201d); INSERT INTO PRICE (STDPRICE, STARTDATE, PRODID, MINPRICE, ENDDATE) VALUES (\u20182.4\u2032, TO_DATE(\u201901-JAN-2005\u2032,\u2019DD-MON-YYYY\u2019), \u2018100870\u2019, \u20181.9\u2019, TO_DATE(\u201901-DEC-2005\u2032,\u2019DD-MON-YYYY\u2019)); INSERT INTO PRICE (STDPRICE, STARTDATE, PRODID, MINPRICE, ENDDATE) VALUES (\u20185.6\u2032, TO_DATE(\u201901-JAN-2006\u2032,\u2019DD-MON-YYYY\u2019), \u2018100871\u2019, \u20184.8\u2019, \u201d); INSERT INTO PRICE (STDPRICE, STARTDATE, PRODID, MINPRICE, ENDDATE) VALUES (\u201924\u2019, TO_DATE(\u201915-FEB-2005\u2032,\u2019DD-MON-YYYY\u2019), \u2018101860\u2019, \u201918\u2019, \u201d); INSERT INTO PRICE (STDPRICE, STARTDATE, PRODID, MINPRICE, ENDDATE) VALUES (\u201812.5\u2032, TO_DATE(\u201915-FEB-2005\u2032,\u2019DD-MON-YYYY\u2019), \u2018101863\u2019, \u20189.4\u2019, \u201d); INSERT INTO PRICE (STDPRICE, STARTDATE, PRODID, MINPRICE, ENDDATE) VALUES (\u20183.4\u2032,TO_DATE( \u201918-AUG-2005\u2032,\u2019DD-MON-YYYY\u2019), \u2018102130\u2019, \u20182.8\u2019, \u201d); INSERT INTO PRICE (STDPRICE, STARTDATE, PRODID, MINPRICE, ENDDATE) VALUES (\u20182.4\u2032, TO_DATE(\u201915-NOV-2006\u2032,\u2019DD-MON-YYYY\u2019), \u2018200376\u2019, \u20181.75\u2019, \u201d); INSERT INTO PRICE (STDPRICE, STARTDATE, PRODID, MINPRICE, ENDDATE) VALUES (\u20184\u2032, TO_DATE(\u201915-NOV-2006\u2032,\u2019DD-MON-YYYY\u2019), \u2018200380\u2019, \u20183.2\u2019, \u201d);
CREATE INDEX PRICE_INDEX ON PRICE(PRODID, STARTDATE); INSERT INTO PRODUCT (PRODID, DESCRIP) VALUES (\u2018100860\u2019, \u2018ACE TENNIS RACKET I\u2019); INSERT INTO PRODUCT (PRODID, DESCRIP) VALUES (\u2018100861\u2019, \u2018ACE TENNIS RACKET II\u2019); INSERT INTO PRODUCT (PRODID, DESCRIP) VALUES (\u2018100870\u2019, \u2018ACE TENNIS BALLS-3 PACK\u2019); INSERT INTO PRODUCT (PRODID, DESCRIP) VALUES (\u2018100871\u2019, \u2018ACE TENNIS BALLS-6 PACK\u2019); INSERT INTO PRODUCT (PRODID, DESCRIP) VALUES (\u2018100890\u2019, \u2018ACE TENNIS NET\u2019); INSERT INTO PRODUCT (PRODID, DESCRIP) VALUES (\u2018101860\u2019, \u2018SP TENNIS RACKET\u2019); INSERT INTO PRODUCT (PRODID, DESCRIP) VALUES (\u2018101863\u2019, \u2018SP JUNIOR RACKET\u2019); INSERT INTO PRODUCT (PRODID, DESCRIP) VALUES (\u2018102130\u2019, \u2018RH: \u201cGUIDE TO TENNIS\u201d\u2018); INSERT INTO PRODUCT (PRODID, DESCRIP) VALUES (\u2018200376\u2019, \u2018SB ENERGY BAR-6 PACK\u2019); INSERT INTO PRODUCT (PRODID, DESCRIP) VALUES (\u2018200380\u2019, \u2018SB VITA SNACK-6 PACK\u2019);
commit;<\/p>\n

Drop table dept cascade constraints; Drop table emp cascade constraints; Drop table customer cascade constraints; Drop table product cascade constraints; Drop table ord cascade constraints; Drop table item cascade constraints; Drop table salgrade cascade constraints; Drop table bonus cascade constraints; Drop table price cascade constraints; Drop table dummy cascade constraints;
Purge RecycleBin;
CREATE TABLE DEPT ( DEPTNO NUMBER(2) NOT NULL, DNAME VARCHAR2(14), LOC VARCHAR2(13), CONSTRAINT DEPT_PRIMARY_KEY PRIMARY KEY (DEPTNO)); INSERT INTO DEPT VALUES (10,\u2019ACCOUNTING\u2019,\u2019NEW YORK\u2019); INSERT INTO DEPT VALUES (20,\u2019RESEARCH\u2019,\u2019DALLAS\u2019); INSERT INTO DEPT VALUES (30,\u2019SALES\u2019,\u2019CHICAGO\u2019); INSERT INTO DEPT VALUES (40,\u2019OPERATIONS\u2019,\u2019BOSTON\u2019);
CREATE TABLE EMP ( EMPNO NUMBER(4) NOT NULL, ENAME VARCHAR2(10), JOB VARCHAR2(9), MGR NUMBER(4) CONSTRAINT EMP_MGR_FK REFERENCES EMP (EMPNO), HIREDATE DATE, SAL NUMBER(7,2), COMM NUMBER(7,2), DEPTNO NUMBER(2) NOT NULL, CONSTRAINT EMP_DEPTNO_FK FOREIGN KEY (DEPTNO) REFERENCES DEPT (DEPTNO), CONSTRAINT EMP_EMPNO_PK PRIMARY KEY (EMPNO)); INSERT INTO EMP VALUES (7839,\u2019KING\u2019,\u2019PRESIDENT\u2019,NULL,TO_DATE(\u201917-NOV-2001\u2032,\u2019DD-MON-YYYY\u2019),15000,NULL,10); INSERT INTO EMP VALUES (7698,\u2019Blake\u2019,\u2019MANAGER\u2019,7839,TO_DATE(\u20181-MAY-2001\u2032,\u2019DD-MON-YYYY\u2019),6850,NULL,30); INSERT INTO EMP VALUES (7782,\u2019CLARK\u2019,\u2019MANAGER\u2019,7839,TO_DATE(\u20189-JUN-2001\u2032,\u2019DD-MON-YYYY\u2019),5450,NULL,10); INSERT INTO EMP VALUES (7566,\u2019Jones\u2019,\u2019MANAGER\u2019,7839,TO_DATE(\u20182-APR-2001\u2032,\u2019DD-MON-YYYY\u2019),5975,NULL,20); INSERT INTO EMP VALUES (7654,\u2019Martin\u2019,\u2019SALESMAN\u2019,7698,TO_DATE(\u201928-SEP-2001\u2032,\u2019DD-MON-YYYY\u2019),4250,27400,30); INSERT INTO EMP VALUES (7499,\u2019ALLEN\u2019,\u2019SALESMAN\u2019,7698,TO_DATE(\u201920-FEB-2001\u2032,\u2019DD-MON-YYYY\u2019),3600,16300,30); INSERT INTO EMP VALUES (7844,\u2019TURNER\u2019,\u2019SALESMAN\u2019,7698,TO_DATE(\u20188-SEP-2001\u2032,\u2019DD-MON-YYYY\u2019),3500,0,30); INSERT INTO EMP VALUES (7900,\u2019James\u2019,\u2019CLERK\u2019,7698,TO_DATE(\u20183-DEC-2001\u2032,\u2019DD-MON-YYYY\u2019),4950,NULL,30); INSERT INTO EMP VALUES (7521,\u2019WARD\u2019,\u2019SALESMAN\u2019,7698,TO_DATE(\u201922-FEB-2001\u2032,\u2019DD-MON-YYYY\u2019),3250,55500,30); INSERT INTO EMP VALUES (7902,\u2019ford\u2019,\u2019ANALYST\u2019,7566,TO_DATE(\u20183-DEC-2001\u2032,\u2019DD-MON-YYYY\u2019),6000,NULL,20); INSERT INTO EMP VALUES (7369,\u2019SMITH\u2019,\u2019CLERK\u2019,7902,TO_DATE(\u201917-DEC-2000\u2032,\u2019DD-MON-YYYY\u2019),3800,NULL,20); INSERT INTO EMP VALUES (7788,\u2019SCOTT\u2019,\u2019ANALYST\u2019,7566,TO_DATE(\u201909-DEC-2002\u2032,\u2019DD-MON-YYYY\u2019),6000,NULL,20); INSERT INTO EMP VALUES (7876,\u2019ADAMS\u2019,\u2019CLERK\u2019,7788,TO_DATE(\u201912-JAN-2003\u2032,\u2019DD-MON-YYYY\u2019),4100,NULL,20); INSERT INTO EMP VALUES (7934,\u2019MILLER\u2019,\u2019CLERK\u2019,7782,TO_DATE(\u201923-JAN-2002\u2032,\u2019DD-MON-YYYY\u2019),4300,NULL,10);
CREATE TABLE BONUS ( ENAME VARCHAR2(10), JOB VARCHAR2(9), SAL NUMBER, COMM NUMBER);
CREATE TABLE SALGRADE ( GRADE NUMBER, LOSAL NUMBER, HISAL NUMBER); INSERT INTO SALGRADE VALUES (1,700,1200); INSERT INTO SALGRADE VALUES (2,1201,1400); INSERT INTO SALGRADE VALUES (3,1401,2000); INSERT INTO SALGRADE VALUES (4,2001,3000); INSERT INTO SALGRADE VALUES (5,3001,9999);
CREATE TABLE DUMMY ( DUMMY NUMBER ); INSERT INTO DUMMY VALUES (0);
CREATE TABLE CUSTOMER ( CUSTID NUMBER (6) NOT NULL, NAME VARCHAR2 (45), ADDRESS VARCHAR2 (40), CITY VARCHAR2 (30), STATE VARCHAR2 (2), ZIP VARCHAR2 (9), AREA NUMBER (3), PHONE VARCHAR2 (9), REPID NUMBER (4) NOT NULL, CREDITLIMIT NUMBER (9,2), COMMENTS VARCHAR2 (256), CONSTRAINT CUSTOMER_CUSTID_PK PRIMARY KEY (CUSTID), CONSTRAINT CUSTOMER_CUSTID_CK CHECK (CUSTID > 0));
CREATE TABLE ORD ( ORDID NUMBER (4) NOT NULL, ORDERDATE DATE, COMMPLAN VARCHAR2 (1), CUSTID NUMBER (6) NOT NULL, SHIPDATE DATE, TOTAL NUMBER (8,2) CONSTRAINT ORD_TOTAL_CK CHECK (TOTAL >= 0), CONSTRAINT ORD_CUSTID_FK FOREIGN KEY (CUSTID) REFERENCES CUSTOMER (CUSTID), CONSTRAINT ORD_ORDID_PK PRIMARY KEY (ORDID));
CREATE TABLE ITEM ( ORDID NUMBER (4) NOT NULL, ITEMID NUMBER (4) NOT NULL, PRODID NUMBER (6), ACTUALPRICE NUMBER (8,2), QTY NUMBER (8), ITEMTOT NUMBER (8,2), CONSTRAINT ITEM_ORDID_FK FOREIGN KEY (ORDID) REFERENCES ORD (ORDID), CONSTRAINT ITEM_ORDID_ITEMID_PK PRIMARY KEY (ORDID,ITEMID));
CREATE TABLE PRODUCT ( PRODID NUMBER (6) CONSTRAINT PRODID_PK PRIMARY KEY, DESCRIP VARCHAR2 (30));
CREATE TABLE PRICE ( PRODID NUMBER (6) NOT NULL, STDPRICE NUMBER (8,2), MINPRICE NUMBER (8,2), STARTDATE DATE,
ENDDATE DATE);
INSERT INTO CUSTOMER (ZIP, STATE, REPID, PHONE, NAME, CUSTID, CREDITLIMIT, CITY, AREA, ADDRESS, COMMENTS) VALUES (\u201896711\u2019, \u2018CA\u2019, \u20187844\u2019, \u2018598-6609\u2019, \u2018JOCKSPORTS\u2019, \u2018100\u2019, \u20185000\u2019, \u2018BELMONT\u2019, \u2018415\u2019, \u2018345 VIEWRIDGE\u2019, \u2018Very friendly people to work with \u2014 sales rep likes to be called Mike.\u2019); INSERT INTO CUSTOMER (ZIP, STATE, REPID, PHONE, NAME, CUSTID, CREDITLIMIT, CITY, AREA, ADDRESS, COMMENTS) VALUES (\u201894061\u2019, \u2018CA\u2019, \u20187521\u2019, \u2018368-1223\u2019, \u2018TKB SPORT SHOP\u2019, \u2018101\u2019, \u201810000\u2019, \u2018REDWOOD CITY\u2019, \u2018415\u2019, \u2018490 BOLI RD.\u2019, \u2018Rep called 5\/8 about change in order \u2013 contact shipping.\u2019); INSERT INTO CUSTOMER (ZIP, STATE, REPID, PHONE, NAME, CUSTID, CREDITLIMIT, CITY, AREA, ADDRESS, COMMENTS) VALUES (\u201895133\u2019, \u2018CA\u2019, \u20187654\u2019, \u2018644-3341\u2019, \u2018VOLLYRITE\u2019, \u2018102\u2019, \u20187000\u2019, \u2018BURLINGAME\u2019, \u2018415\u2019, \u20189722 HAMILTON\u2019, \u2018Company doing heavy promotion beginning 10\/89. Prepare for large orders during winter.\u2019); INSERT INTO CUSTOMER (ZIP, STATE, REPID, PHONE, NAME, CUSTID, CREDITLIMIT, CITY, AREA, ADDRESS, COMMENTS) VALUES (\u201897544\u2019, \u2018CA\u2019, \u20187521\u2019, \u2018677-9312\u2019, \u2018JUST TENNIS\u2019, \u2018103\u2019, \u20183000\u2019, \u2018BURLINGAME\u2019, \u2018415\u2019, \u2018HILLVIEW MALL\u2019, \u2018Contact rep about new line of tennis rackets.\u2019); INSERT INTO CUSTOMER (ZIP, STATE, REPID, PHONE, NAME, CUSTID, CREDITLIMIT, CITY, AREA, ADDRESS, COMMENTS) VALUES (\u201893301\u2019, \u2018CA\u2019, \u20187499\u2019, \u2018996-2323\u2019, \u2018EVERY MOUNTAIN\u2019, \u2018104\u2019, \u201810000\u2019, \u2018CUPERTINO\u2019, \u2018408\u2019, \u2018574 SUYYYYY RD.\u2019, \u2018Customer with high market share (23%) due to aggressive advertising.\u2019); INSERT INTO CUSTOMER (ZIP, STATE, REPID, PHONE, NAME, CUSTID, CREDITLIMIT, CITY, AREA, ADDRESS, COMMENTS) VALUES (\u201891003\u2019, \u2018CA\u2019, \u20187844\u2019, \u2018376-9966\u2019, \u2018K + T SPORTS\u2019, \u2018105\u2019, \u20185000\u2019, \u2018SANTA CLARA\u2019, \u2018408\u2019, \u20183476 EL PASEO\u2019, \u2018Tends to order large amounts of merchandise at once. Accounting is considering raising their credit limit. Usually pays on time.\u2019); INSERT INTO CUSTOMER (ZIP, STATE, REPID, PHONE, NAME, CUSTID, CREDITLIMIT, CITY, AREA, ADDRESS, COMMENTS) VALUES (\u201894301\u2019, \u2018CA\u2019, \u20187521\u2019, \u2018364-9777\u2019, \u2018SHAPE UP\u2019, \u2018106\u2019, \u20186000\u2019, \u2018PALO ALTO\u2019, \u2018415\u2019, \u2018908 SEQUOIA\u2019, \u2018Support intensive. Orders small amounts (< 800) of merchandise at a time.\u2019); INSERT INTO CUSTOMER (ZIP, STATE, REPID, PHONE, NAME, CUSTID, CREDITLIMIT, CITY, AREA, ADDRESS, COMMENTS) VALUES (\u201893301\u2019, \u2018CA\u2019, \u20187499\u2019, \u2018967-4398\u2019, \u2018WOMENS SPORTS\u2019, \u2018107\u2019, \u201810000\u2019, \u2018SUNNYVALE\u2019, \u2018408\u2019, \u2018VALCO VILLAGE\u2019, \u2018First sporting goods store geared exclusively towards women. Unusual promotion al style and very willing to take chances towards new products!\u2019); INSERT INTO CUSTOMER (ZIP, STATE, REPID, PHONE, NAME, CUSTID, CREDITLIMIT, CITY, AREA, ADDRESS, COMMENTS) VALUES (\u201855649\u2019, \u2018MN\u2019, \u20187844\u2019, \u2018566-9123\u2019, \u2018NORTH WOODS HEALTH AND FITNESS SUPPLY CENTER\u2019, \u2018108\u2019, \u20188000\u2019, \u2018HIBBING\u2019, \u2018612\u2019, \u201998 LONE PINE WAY\u2019, \u201d); INSERT INTO ORD (TOTAL, SHIPDATE, ORDID, ORDERDATE, CUSTID, COMMPLAN) VALUES (\u2018101.4\u2032, TO_DATE(\u201908-JAN-2007\u2032,\u2019DD-MON-YYYY\u2019), \u2018610\u2019, TO_DATE(\u201907-JAN-2007\u2032,\u2019DD-MON-YYYY\u2019), \u2018101\u2019, \u2018A\u2019); INSERT INTO ORD (TOTAL, SHIPDATE, ORDID, ORDERDATE, CUSTID, COMMPLAN) VALUES (\u201945\u2019, TO_DATE(\u201911-JAN-2007\u2032,\u2019DD-MON-YYYY\u2019), \u2018611\u2019, TO_DATE(\u201911-JAN-2007\u2032,\u2019DD-MON-YYYY\u2019), \u2018102\u2019, \u2018B\u2019);
INSERT INTO ORD (TOTAL, SHIPDATE, ORDID, ORDERDATE, CUSTID, COMMPLAN) VALUES (\u20185860\u2032, TO_DATE(\u201920-JAN-2007\u2032,\u2019DD-MON-YYYY\u2019), \u2018612\u2019, TO_DATE(\u201915-JAN-2007\u2032,\u2019DD-MON-YYYY\u2019), \u2018104\u2019, \u2018C\u2019); INSERT INTO ORD (TOTAL, SHIPDATE, ORDID, ORDERDATE, CUSTID, COMMPLAN) VALUES (\u20182.4\u2032, TO_DATE(\u201930-MAY-2006\u2032,\u2019DD-MON-YYYY\u2019), \u2018601\u2019, TO_DATE(\u201901-MAY-2006\u2032,\u2019DD-MON-YYYY\u2019), \u2018106\u2019, \u2018A\u2019); INSERT INTO ORD (TOTAL, SHIPDATE, ORDID, ORDERDATE, CUSTID, COMMPLAN) VALUES (\u201956\u2019, TO_DATE(\u201920-JUN-2006\u2032,\u2019DD-MON-YYYY\u2019), \u2018602\u2019, TO_DATE(\u201905-JUN-2006\u2032,\u2019DD-MON-YYYY\u2019), \u2018102\u2019, \u2018B\u2019); INSERT INTO ORD (TOTAL, SHIPDATE, ORDID, ORDERDATE, CUSTID, COMMPLAN) VALUES (\u2018698\u2032, TO_DATE(\u201930-JUN-2006\u2032,\u2019DD-MON-YYYY\u2019), \u2018604\u2019, TO_DATE(\u201915-JUN-2006\u2032,\u2019DD-MON-YYYY\u2019), \u2018106\u2019, \u2018A\u2019); INSERT INTO ORD (TOTAL, SHIPDATE, ORDID, ORDERDATE, CUSTID, COMMPLAN) VALUES (\u20188324\u2032,TO_DATE( \u201930-JUL-2006\u2032,\u2019DD-MON-YYYY\u2019), \u2018605\u2019, TO_DATE(\u201914-JUL-2006\u2032,\u2019DD-MON-YYYY\u2019), \u2018106\u2019, \u2018A\u2019); INSERT INTO ORD (TOTAL, SHIPDATE, ORDID, ORDERDATE, CUSTID, COMMPLAN) VALUES (\u20183.4\u2032, TO_DATE(\u201930-JUL-2006\u2032,\u2019DD-MON-YYYY\u2019), \u2018606\u2019, TO_DATE(\u201914-JUL-2006\u2032,\u2019DD-MON-YYYY\u2019), \u2018100\u2019, \u2018A\u2019); INSERT INTO ORD (TOTAL, SHIPDATE, ORDID, ORDERDATE, CUSTID, COMMPLAN) VALUES (\u201897.5\u2032, TO_DATE(\u201915-AUG-2006\u2032,\u2019DD-MON-YYYY\u2019), \u2018609\u2019, TO_DATE(\u201901-AUG-2006\u2032,\u2019DD-MON-YYYY\u2019), \u2018100\u2019, \u2018B\u2019); INSERT INTO ORD (TOTAL, SHIPDATE, ORDID, ORDERDATE, CUSTID, COMMPLAN) VALUES (\u20185.6\u2032, TO_DATE(\u201918-JUL-2006\u2032,\u2019DD-MON-YYYY\u2019), \u2018607\u2019, TO_DATE(\u201918-JUL-2006\u2032,\u2019DD-MON-YYYY\u2019), \u2018104\u2019, \u2018C\u2019); INSERT INTO ORD (TOTAL, SHIPDATE, ORDID, ORDERDATE, CUSTID, COMMPLAN) VALUES (\u201835.2\u2032, TO_DATE(\u201925-JUL-2006\u2032,\u2019DD-MON-YYYY\u2019), \u2018608\u2019, TO_DATE(\u201925-JUL-2006\u2032,\u2019DD-MON-YYYY\u2019), \u2018104\u2019, \u2018C\u2019); INSERT INTO ORD (TOTAL, SHIPDATE, ORDID, ORDERDATE, CUSTID, COMMPLAN) VALUES (\u2018224\u2032, TO_DATE(\u201905-JUN-2006\u2032,\u2019DD-MON-YYYY\u2019), \u2018603\u2019, TO_DATE(\u201905-JUN-2006\u2032,\u2019DD-MON-YYYY\u2019), \u2018102\u2019, \u201d); INSERT INTO ORD (TOTAL, SHIPDATE, ORDID, ORDERDATE, CUSTID, COMMPLAN) VALUES (\u20184450\u2032, TO_DATE(\u201912-MAR-2007\u2032,\u2019DD-MON-YYYY\u2019), \u2018620\u2019, TO_DATE(\u201912-MAR-2007\u2032,\u2019DD-MON-YYYY\u2019), \u2018100\u2019, \u201d); INSERT INTO ORD (TOTAL, SHIPDATE, ORDID, ORDERDATE, CUSTID, COMMPLAN) VALUES (\u20186400\u2032, TO_DATE(\u201901-FEB-2007\u2032,\u2019DD-MON-YYYY\u2019), \u2018613\u2019, TO_DATE(\u201901-FEB-2007\u2032,\u2019DD-MON-YYYY\u2019), \u2018108\u2019, \u201d); INSERT INTO ORD (TOTAL, SHIPDATE, ORDID, ORDERDATE, CUSTID, COMMPLAN) VALUES (\u201823940\u2032, TO_DATE(\u201905-FEB-2007\u2032,\u2019DD-MON-YYYY\u2019), \u2018614\u2019, TO_DATE(\u201901-FEB-2007\u2032,\u2019DD-MON-YYYY\u2019), \u2018102\u2019, \u201d); INSERT INTO ORD (TOTAL, SHIPDATE, ORDID, ORDERDATE, CUSTID, COMMPLAN) VALUES (\u2018764\u2032, TO_DATE(\u201910-FEB-2007\u2032,\u2019DD-MON-YYYY\u2019), \u2018616\u2019, TO_DATE(\u201903-FEB-2007\u2032,\u2019DD-MON-YYYY\u2019), \u2018103\u2019, \u201d); INSERT INTO ORD (TOTAL, SHIPDATE, ORDID, ORDERDATE, CUSTID, COMMPLAN) VALUES (\u20181260\u2032, TO_DATE(\u201904-FE<\/p>\n","protected":false},"excerpt":{"rendered":"

Database: SQL developer; SQL statements This assignment requires SQL developer. Please only attempt if you are very familiar with SQL Developer and specifically SQL Statements After logging into SQL developer, you must load the tables to do the assignment. There Read More …<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-132486","post","type-post","status-publish","format-standard","hentry"],"_links":{"self":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/132486","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/comments?post=132486"}],"version-history":[{"count":0,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/posts\/132486\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/media?parent=132486"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/categories?post=132486"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.benedictsol.com\/blogs\/wp-json\/wp\/v2\/tags?post=132486"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}