Re: What happens to this code

surajkumar1_at_gmail.com wrote:
> Examine this code:
> CREATE OR REPLACE STORED FUNCTION get_sal
> (p_raise_amt NUMBER, p_employee_id employees.employee_id%TYPE)
> RETURN NUMBER
> 1z0-147
> Leading the way in IT testing and certification tools, www.testking.com
> - 37 -
> IS
> v_salary NUMBER;
> v_raise NUMBER(8,2);
> BEGIN
> SELECT salary
> INTO v_salary
> FROM employees
> WHERE employee_id = p_employee_id;
> v_raise := p_raise_amt * v_salary;
> RETURN v_raise;
> End;
>
> What happens after execution of this code.

STORED FUNCTION?

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org