Thursday, November 13, 2008

Assigning Values to Variables by SELECTing INTO in PL/SQL

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;
/

No comments:

search engine

Custom Search