This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
kurs:select_into [2010/05/18 11:15] 127.0.0.1 external edit |
kurs:select_into [2014/09/10 21:22] (current) |
||
---|---|---|---|
Line 15: | Line 15: | ||
v_department_name ); | v_department_name ); | ||
END GET_SALARY; | END GET_SALARY; | ||
+ | </code> | ||
+ | |||
+ | <code> | ||
+ | PROCEDURE hr.get_salary( | ||
+ | p_last_name IN varchar2, p_salary OUT number) | ||
+ | as | ||
+ | v_salary number; | ||
+ | BEGIN | ||
+ | select salary into v_salary | ||
+ | from employees | ||
+ | where last_name = p_last_name; | ||
+ | p_salary := v_salary; | ||
+ | dbms_output.put_line(p_salary); | ||
+ | END; | ||
</code> | </code> |