Differences

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

@@ Line 1: / Line 1: @@
+<code>
+PROCEDURE P_RECORD
+ (v_employee_id IN number)
+--  (v_employee_id IN employees.employee_id%TYPE)
+   IS
+   type emp_record_type IS RECORD
+     (last_name varchar2(25),
+      job_id    varchar2(10),
+      salary    number(8,2));
+   v_last_name varchar2(100);
+   v_job_id    varchar2(10);
+   v_salary    number(8,2);
+   emp_rec emp_record_type;
+BEGIN
+  SELECT employees.last_name,
+    employees.job_id,
+    employees.salary
+  INTO
+    emp_rec
+  FROM
+    employees
+  WHERE
+    employees.employee_id = v_employee_id;
+  dbms_output.put_line(emp_rec.last_name||' '||
+                       emp_rec.salary || ' ' ||
+                       emp_rec.job_id
+                      );
+END; -- Procedure
+</code>

dokuwiki