Computer Programming and Analysis APC100 Lecture Notes - Lecture 3: Oracle Database, Sql*Plus
19 Feb 2016
School
Department
Professor
Document Summary
Select statements and results with the cover page. Initiate a sql*plus session using the user id and password provided by your instructor on the zenit server for neptune database: display the department name, city, street address and postal code for all departments. Use the join and using form of syntax. Sort the output by department name descending: display full name of the employees, their hire date and salary together with their department name, but only for departments which names start with a or s. Sort the output by department name and then by last name: rewrite the previous question by using standard (old -- prior to oracle9i) join method, display full name of the manager of each department in provinces ontario, California and washington plus department name, city, postal code and province name. Full name should be in format of : Use the join and on form of syntax.
