When creating a function in SQL *Plus, you receive this message:
“Warning: Function created with compilation errors.” Which command can you issue to see the actual error message?
A.
SHOW FUNCTION_ERROR
B.
SHOW USER_ERRORS
C.
SHOW ERRORS
D.
SHOW ALL_ERRORS
Explanation:
Correct Answer C: The SQL *Plus command SHOW ERRORS or SHOW ERR Command extracts the error information from the USER_ERRORS view Incorrect ErrorsA: this is an invalid object
B & C are Invalid Commands