August 2002
Intermediate to advanced
528 pages
10h 12m
English
| A1: |
Select tname from tab; |
| A2: |
Desc employee or describe employee |
| A3: |
Select fk_department, last_name, first_name, current_position From employee; |
| A4: |
select fk_department,‘Mr. ’||first_name||’‘||last_name, current_position from employee; |
| A5: |
Select last_name, first_name, wages, (wages*1.06)+2300-250 From employee; |
| A6: |
Select fk_department, first_name, last_name From employee order by fk_department; |
| A7: |
Select fk_department, first_name, last_name from employee order by fk_department desc, last_name, first_name; |
| A8: |
Select fk_department, last_name, nvl(wages,0)/52 from employee order by 1, 3; |
| A9: |
Select first_name, last_name from employee where first_name = ‘JOHN’; |
| A10: |
Select first_name, last_name, wages from employee ... |