Index | Home | Forums
Oracle PL/SQL Example 1-3 Assigning Values to Variables by SELECTing INTO

Example 1-3 Assigning Values to Variables by SELECTing INTO

DECLARE
  bonus  NUMBER(8,2);
  emp_id NUMBER(6) := 100;
BEGIN
  SELECT salary * 0.10 INTO bonus FROM employees 
    WHERE employee_id = emp_id;
END;
/



This page was created by oracleabc.com on Feb 23,2008 00:09:02
General comments and questions regarding this document should be sent by email to info@oracleabc.com or post your comments here