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 -> Re: What happens to this code

Re: What happens to this code

From: Ana C. Dent <anacedent_at_hotmail.com>
Date: Sun, 25 Feb 2007 18:57:17 GMT
Message-ID: <h_kEh.48643$1H5.12010@newsfe16.phx>


surajkumar1_at_gmail.com wrote in news: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.
>
>

Everybody gets higher pay. Received on Sun Feb 25 2007 - 12:57:17 CST

Original text of this message

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