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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started