Chapter 8

A1: 
Select last_name, first_name 
from employee 
where first_name = ‘JOHN’ 
union 
select last_name, first_name 
from employee 
where first_name = ‘HAROLD’ 
union 
select last_name, first_name 
from employee 
where first_name = ‘WILLIAM’;
A2: 
Select last_name, first_name 
from employee, emp_tools 
where payroll_number = fk_payroll_number 
minus 
select last_name, first_name 
from employee, glasses 
where payroll_number = fk_payroll_number;
A3: 
Select ‘Born Before 1920’, last_name, first_name, 
        to_char(birth_date,‘DD-MON-YYYY’) 
from employee 
where birth_date < ‘01-JAN-1920’ 
union 
select ‘Born After 1920’, last_name, first_name, 
        to_char(birth_date,‘DD-MON-YYYY’) 
from employee 
where birth_date >= ‘01-JAN-1920’ 
order by 1 desc, 2;
A4: 
 Select ‘Born ...

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