http://www.w3.org/ns/prov#value | - AnonymousJune 11, 2012 at 2:52 PMDECLARE l_sal emp.sal%TYPE; p_empno emp.empno%TYPE := 123; -- Invalid empno numberBEGIN SELECT NVL( ( SELECT sal FROM emp WHERE empno = p_empno ), 0 ) INTO l_sal FROM DUAL;END;/ReplyDeleteBellyJune 14, 2012 at 12:55 AMMartin,In my humble opinion you left out the most important one:Explicitly declare a cursor.All issues solved, except the fact that you must write a
|