Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> What happens to this code

What happens to this code

From: <surajkumar1_at_gmail.com>
Date: 25 Feb 2007 09:51:27 -0800
Message-ID: <1172425887.051518.256860@p10g2000cwp.googlegroups.com>


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. Received on Sun Feb 25 2007 - 11:51:27 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US