Differences

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

--- kurs:select_into [2010/05/18 11:15]
127.0.0.1 external edit
+++ kurs:select_into [2014/09/10 21:22]
@@ 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