|
-
I have this function and I need following result, can anyone see what's wrong with this function? Also, how do I use DBMS_OUTPUT.PUT_LINE to debugg? Thanks!!
CREATE OR REPLACE FUNCTION annual_comp2
(V_SAL IN EMP.SAL%TYPE,
V_COMM IN EMP.COMM%TYPE)
RETURN NUMBER
IS
V_ANNSAL EMP.SAL%TYPE;
BEGIN
SELECT NVL(SAL,0) * 12 + NVL(COMM,0)
INTO V_ANNsal
FROM EMP
WHERE SAL = V_SAL
AND COMM = V_COMM;
dbms_output.put_line ('give me ' || v_sal || 'and ' || v_comm); -- How do I generate any feedback with this?
RETURN V_ANNSAL;
END;
/
REQUIRE RESULT
-------------------
Annual Salary
-------------
60000
34200
29400
35700
16400
19500
18000
11400
15500
36000
9600
36000
13200
15600
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|