Question: Need help with this SQL problem. Please as soon as possible. Thanks people of chegg. Run sqlplus iggy/oracle. (It is assumed that you have already

Need help with this SQL problem. Please as soon as possible. Thanks people of chegg.

  • Run sqlplus iggy/oracle. (It is assumed that you have already run the LoadDB.sql script last week that built the required user and tables.)
  • Type SPOOL c:\cis4210\M2spool.txt .
  • Write a single SQL statement that lists all suppliers supplying only hammers using the difference operation (MINUS).
  • When finished, stop the spooling and exit the program. (You may edit the spool file for clarity if you wish.)

Data is:

SQL> DESCRIBE iggy.part; Name Null? Type ----------------------------------------- -------- ---------------------------- PARTNAME NOT NULL VARCHAR2(32)

SQL> SELECT * FROM iggy.part;

PARTNAME -------------------------------- HAMMER NAIL

SQL> DESCRIBE iggy.supplier; Name Null? Type ----------------------------------------- -------- ---------------------------- SUPPLIERNAME NOT NULL VARCHAR2(32)

SQL> SELECT * FROM iggy.supplier;

SUPPLIERNAME -------------------------------- NEW YANKEE WORKSHOP, INC. OLD YANKEE WORKSHOP, INC. TOOL TIME, INC.

SQL> DESCRIBE iggy.quote; Name Null? Type ----------------------------------------- -------- ---------------------------- SUPPLIERNAME NOT NULL VARCHAR2(32) PARTNAME NOT NULL VARCHAR2(32) QUOTE NOT NULL NUMBER(8,2)

SQL> SELECT * FROM iggy.quote;

SUPPLIERNAME PARTNAME QUOTE -------------------------------- -------------------------------- ---------- NEW YANKEE WORKSHOP, INC. HAMMER 1.89 NEW YANKEE WORKSHOP, INC. NAIL .19 OLD YANKEE WORKSHOP, INC. HAMMER 2.09 TOOL TIME, INC. HAMMER 1.99 TOOL TIME, INC. NAIL .2

SQL> SPOOL OFF;

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!