August 2002
Intermediate to advanced
528 pages
10h 12m
English
| A1: |
Select lower(department_name), upper(last_name), initcap(first_name) from department, employee where department = fk_department; |
| A2: |
Select lpad(department_name, 20,‘#’), rpad(last_name, 25,‘-’) From department, employee Where department = fk_department; |
| A3: |
Select first_name||’‘||last_name, length(first_name||’‘||last_name) from employee; |
| A4: |
Select first_name, substr(first_name, 2,2) from employee; |