This shows you the differences between two versions of the page.
kurs:table_als_tabellendatentyp [2010/05/19 13:36] mh created |
kurs:table_als_tabellendatentyp [2010/05/19 13:46] mh |
||
---|---|---|---|
Line 21: | Line 21: | ||
BEGIN | BEGIN | ||
- | |||
- | for r_ed in (select department_name from dep_emp) loop | ||
- | t_emp(r_ed.department_name) := emp_list(); | ||
- | end loop; | ||
for r_ed in (SELECT FIRST_NAME||' '||LAST_NAME e_name, DEPARTMENT_NAME | for r_ed in (SELECT FIRST_NAME||' '||LAST_NAME e_name, DEPARTMENT_NAME | ||
Line 30: | Line 26: | ||
WHERE ( (DEPARTMENTS.DEPARTMENT_ID = EMPLOYEES.DEPARTMENT_ID) )) | WHERE ( (DEPARTMENTS.DEPARTMENT_ID = EMPLOYEES.DEPARTMENT_ID) )) | ||
loop | loop | ||
+ | if (not t_emp.exists(r_ed.department_name)) then | ||
+ | t_emp(r_ed.department_name) := emp_list(); | ||
+ | end if; | ||
t_emp(r_ed.department_name).extend; | t_emp(r_ed.department_name).extend; | ||
- | t_emp(r_ed.department_name) | + | t_emp(r_ed.department_name)(t_emp(r_ed.department_name).last) := r_ed.e_name; |
- | (t_emp(r_ed.department_name).last):= r_ed.e_name; | + | |
end loop; | end loop; | ||
Line 44: | Line 42: | ||
- | + | END; | |
- | END; -- Procedure | + | |
</code> | </code> | ||