Usetutoringspotscode to get 8% OFF on your first order!

  • time icon24/7 online - support@tutoringspots.com
  • phone icon1-316-444-1378 or 44-141-628-6690
  • login iconLogin

Written Assignment 3

Run SQL*Plus iggy/oracle. (It is assumed that you have already run theLoadDB.sql script last week that built the required user and tables.)
Type SPOOL c:cis4210M3spool.txt .
Write a single SQL statement that lists all suppliers supplying only hammers WITHOUT using the difference operation. (A join or subquery would be appropriate.)
When finished, stop the spooling and exit the program. (You may edit the spool file for clarity if you wish.)
Submit your text document with the file name c:cis4210M3spool.txt .

You can leave a response, or trackback from your own site.

Leave a Reply

Powered by WordPress | Designed by: Premium WordPress Themes | Thanks to Themes Gallery, Bromoney and Wordpress Themes