kurs:cursor_mit_parameter
Differences
This shows you the differences between two versions of the page.
| — |
kurs:cursor_mit_parameter [2014/09/10 21:22] (current) |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| + | <code> | ||
| + | PROCEDURE P_EMP_CURSOR | ||
| + | ( in_last_name IN varchar2 ) | ||
| + | IS | ||
| + | cursor get_emp(p_last_name varchar2) is | ||
| + | select * from | ||
| + | bonus | ||
| + | where last_name = p_last_name; | ||
| + | |||
| + | BEGIN | ||
| + | for emp_rec in get_emp(in_last_name) loop | ||
| + | dbms_output.put_line(emp_rec.first_name||' '||emp_rec.last_name); | ||
| + | end loop; | ||
| + | END; | ||
| + | </code> | ||
kurs/cursor_mit_parameter.txt ยท Last modified: 2014/09/10 21:22 (external edit)
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
