WELCOME, GUEST
 
 
Minimize
Toad World Puzzler - March 2008

Do you know your built-in functions?

Oracle offers a number of built-in functions to provide information about errors. Test your knowledge of these functions below.
 






A.

EXCEPTION
   WHEN OTHERS THEN
       INSERT INTO error_log VALUES (SQLCODE, SQLERRM, SYSDATE);
       RAISE;
END;

B.

EXCEPTION
   WHEN OTHERS THEN
       INSERT INTO error_log VALUES (SQLCODE, 'Employee too young!', SYSDATE);
       RAISE;
END;

C.

EXCEPTION
   WHEN OTHERS THEN
   DECLARE l_code PLS_INTEGER := SQLCODE; BEGIN
       INSERT INTO error_log VALUES (l_code, 'Employee too young!', SYSDATE);
       RAISE;
       END;
END;


Submit