August 2002
Intermediate to advanced
528 pages
10h 12m
English
| 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 ... |