Differences

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

--- kurs:v_cursor [2014/09/10 21:22]
+++ kurs:v_cursor [2014/09/10 21:22] (current)
@@ Line 1: / Line 1: @@
+<code>
+PROCEDURE P_CURSOR_FEATURES (dep_name departments.department_name%type)
+   IS
+   cursor c_emp is
+      SELECT   employees.first_name, employees.last_name,
+               jobs.job_title
+        FROM employees, departments, jobs
+        WHERE (departments.department_id = employees.department_id)
+        AND   (jobs.job_id = employees.job_id)
+        AND   (departments.department_name = dep_name)
+        ORDER BY employees.last_name ASC;
+   type emp_rec_type is record
+       (first_name employees.first_name%type,
+        last_name  employees.last_name%type,
+        job_title  jobs.job_title%type);
+   emp_rec emp_rec_type;
+BEGIN
+ open c_emp;
+ dbms_output.put_line('Department_name:'||' '||
+                      dep_name);
+ for i in 1..5 loop
+    fetch c_emp into emp_rec;
+    dbms_output.put_line('First_name: '||
+                         emp_rec.first_name||' '||
+                         '     Last_name:'||' '||
+                         emp_rec.last_name||' '||
+                         '     Job_title:'||' '||
+                         emp_rec.job_title
+                         );
+ end loop;
+ close c_emp;
+END; -- Procedure
+</code>

dokuwiki