This shows you the differences between two versions of the page.
Both sides previous revision Previous revision | Next revision Both sides next revision | ||
kurs:plsql_tables [2014/09/10 21:22] 127.0.0.1 external edit |
kurs:plsql_tables [2014/11/24 13:53] mh |
||
---|---|---|---|
Line 1: | Line 1: | ||
+ | == PLSQL Table übergeben == | ||
+ | |||
+ | <code> | ||
+ | -------------------------------------------------------- | ||
+ | -- DDL for Package PCK_EMPLOYEES | ||
+ | -------------------------------------------------------- | ||
+ | |||
+ | CREATE OR REPLACE PACKAGE "HR"."PCK_EMPLOYEES" AS | ||
+ | |||
+ | cursor c_emp_dep(cp_department_name varchar2) is | ||
+ | select employee_id, | ||
+ | first_name, | ||
+ | last_name, | ||
+ | salary, | ||
+ | department_name | ||
+ | from employees e join departments d | ||
+ | on e.department_id = d.department_id | ||
+ | where department_name = cp_department_name; | ||
+ | | ||
+ | type type_emp_dep is table of c_emp_dep%rowtype | ||
+ | index by binary_integer; | ||
+ | |||
+ | procedure get_emp_per_dep_name( | ||
+ | p_department_name in departments.department_name%type, | ||
+ | t_emp_dep out type_emp_dep); | ||
+ | |||
+ | procedure print_emp_dep(t_emp_dep in type_emp_dep); | ||
+ | /* | ||
+ | procedure get_emp_per_dep_name (p_department_name in | ||
+ | type_emp_dep out von einem zu definierenden table type | ||
+ | |||
+ | procedure print_emp_dep(type_emp_dep in) | ||
+ | ) | ||
+ | |||
+ | |||
+ | |||
+ | */ | ||
+ | |||
+ | procedure next_emp; | ||
+ | |||
+ | END PCK_EMPLOYEES; | ||
+ | |||
+ | / | ||
+ | </code> | ||
+ | |||
+ | |||
+ | |||
10 zufällige, nicht doppelte Employees ziehen | 10 zufällige, nicht doppelte Employees ziehen | ||
Line 65: | Line 112: | ||
END PLSQL_TABLE; | END PLSQL_TABLE; | ||
</code> | </code> | ||
+ | |||
+ |