Hello, you are not logged in.  Login or sign up
Experts >> Steven Feuerstein's PL/SQL Obsession >> Puzzles and Quizzes >> Mar 2008: Do you know built-in functions?
Search Toad World Search
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
Copyright 2008 by Quest Software  | Terms Of Use | Privacy Statement | Contact Us