Multiple choice technology databases

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

  1. USER_PROCEDURES

  2. USER_PROCS

  3. USER_OBJECTS

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

USER_OBJECTS is the correct view to query for information about compiled objects including procedures, functions, and packages. It contains the LAST_DDL_TIME column which shows when an object was last compiled or modified. USER_PROCEDURES doesn't exist in Oracle, and the other options are not standard views.

Keep practicing — related questions