Differences

This shows you the differences between two versions of the page.

--- kurs:plsql_tables [2014/04/08 13:17]
mh created
+++ 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>
 zufällige, nicht doppelte Employees ziehen
@@ Line 65: / Line 112: @@
 END PLSQL_TABLE;
 </code>

dokuwiki