Oracle SQL and PL/SQL Handbook: A Guide for Data Administrators, Developers, and Business Analysts

Practice

1:	Log on to SQL*Plus.
2:	Enter and execute the following command in SQL*Plus: select fk_department, last_name from employee;
3:	Enter and execute the following command in SQL*Plus (enter the command on multiple lines): select fk_department, last_name from employee; order by fk_department, last_name;
4:	List the command entered in question 3.
5:	List the first line of the current command.
6:	Change last_name to first_name.
7:	Save the current command to a file.
8:	Execute the file.
9:	Create the tables that were designed in Chapter 1.
10:	Drop the tables that you created in exercise 9.
11:	Re-create the tables created in Chapter 1, with the following constraints: Each table should have PRIMARY KEY constraints. Child tables should have FOREIGN ...