Differences

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

--- kurs:cursor [2014/09/10 21:22]
+++ kurs:cursor [2014/09/10 21:22] (current)
@@ Line 1: / Line 1: @@
+<code>
+PROCEDURE PC_CURSOR
+   IS
+    cursor c_max_salary is
+        SELECT employees.first_name, employees.last_name, jobs.job_id, jobs.job_title,
+            jobs.min_salary, jobs.max_salary
+        FROM jobs, employees
+        WHERE ((jobs.job_id = employees.job_id));
+    type job_emp is record (
+        first_name varchar2(20),
+        last_name varchar2(20),
+        job_id varchar2(10),
+        job_title varchar2(35),
+        min_salary number(6),
+        max_salary number(6));
+    jobs_record job_emp;
+BEGIN
+    open c_max_salary;
+    for iInd in 1..9 loop
+        fetch c_max_salary into jobs_record;
+        dbms_output.put_line(jobs_record.last_name||' '||jobs_record.job_id||' '||jobs_record.job_title||' '||jobs_record.max_salary);
+    end loop;
+    close c_max_salary;
+END; -- Procedure
+</code>

dokuwiki