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.