kurs:table_als_tabellendatentyp
Differences
This shows you the differences between two versions of the page.
| Next revision | Previous revision | ||
|
kurs:table_als_tabellendatentyp [2010/05/19 13:36] mh created |
kurs:table_als_tabellendatentyp [2014/09/10 21:22] (current) |
||
|---|---|---|---|
| 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> | ||
kurs/table_als_tabellendatentyp.1274269014.txt.gz · Last modified: 2014/09/10 21:22 (external edit)
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
