Computer Science 455
Second Exercise Set
Due: Monday, Feb. 14.
Write SQL statements for the following queries:
The command file should have the following format:
set echo on
/* your name */ /* Find full details of all projects in London */ select ... etc. /* Get supplier number values for suppliers who supply project J1 */ select .... etc. . . . exit
Turn in (in class on Monday) a printout of what happens when the command file is run (use the SPOOL command in SQL PLUS).
Any questions? Please let me know. Many thanks!