Multiple choice technology databases

Which table should you query to determine when your procedure was last compiled?

  1. USER_OBJECTS

  2. USER_PROCEDURES

  3. USER_PROCS

  4. USER_PLSQL_UNITS
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

USER_OBJECTS is the correct view to find compilation timestamps for stored procedures. It contains information about all schema objects including procedures, functions, packages, and their last modification dates (LAST_DDL_TIME). USER_PROCEDURES and USER_PROCS don't exist as standard views. USER_PLSQL_UNITS is not a valid Oracle view.

Keep practicing — related questions