Differences

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

--- kurs:select_into [2009/10/14 14:46]
mh created
+++ kurs:select_into [2010/05/18 11:15]
127.0.0.1 external edit
@@ Line 1: / Line 1: @@
+<code>
+PROCEDURE GET_SALARY
+( p_last_name IN VARCHAR2, p_first_name in varchar2 ) AS
+  v_salary number;
+  v_department_name varchar2(50);
+BEGIN
+-- hier werden die felder selektiert
+  select salary, department_name into v_salary, v_department_name
+   from employees e, departments d
+      where last_name       = p_last_name and
+            first_name      = p_first_name and
+            e.department_id = d.department_id;
+  dbms_output.put_line(p_first_name||' '||
+       p_last_name || ' verdient ' || v_salary ||' und arbeitet in ' ||
+       v_department_name );
+END GET_SALARY;
+</code>

dokuwiki