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 Errors
A: this is an invalid object
B & C: are Invalid Commands