Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions

Question

The amount of work I am asked to do is reasonable.

Answered: 1 week ago

Question

The company encourages a balance between work and personal life.

Answered: 1 week ago