Chapter 5

A1: 
Select last_name, first_name, purchase_date, optician 
from employee, glasses 
where payroll_number = fk_payroll_number;
A2: 
Select last_name, first_name, purchase_date, optician 
from employee, glasses 
where payroll_number = fk_payroll_number(+);
A3: 
Select department_name, last_name, first_name, purchase_date, optician 
from department, employee, glasses 
where department = fk_department 
 and payroll_number = fk_payroll_number;
A4: 
Select department_name, last_name, first_name, purchase_date, optician 
from department d, employee e, glasses g 
where d.department = e.fk_department 
 and e.payroll_number = g.fk_payroll_number;
A5: 
Select min(wages) from employee;
A6: 
Select max(wages) from employee;
A7: 
 Select min(street), ...

Get Oracle SQL and PL/SQL Handbook: A Guide for Data Administrators, Developers, and Business Analysts now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial