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

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

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

A.
USER_PROCEDURES

B.
USER_PROCS

C.
USER_OBJECTS

D.
USER_PLSQL_UNITS

Explanation:
In the USER_OBJECTS there is
Incorrect Answers

A: USER_PROCEDURES lists all functions and procedures, along with associated properties. For example, ALL_PROCEDURES indicates whether or not a function is pipelined, parallel enabled or an aggregate function. If a function is pipelined or an aggregate function, the associated implementation type (if any) is also identified. It doesn’t have when the object was last complied.
B: There is nothing called USER_PROCS.
D: There is nothing called USER_PLSQL_UNITS



Leave a Reply 1

Your email address will not be published. Required fields are marked *


Vidyasagar Kotte

Vidyasagar Kotte

The answer is C:USER_OBJECTS:

LAST_DDL_TIME is the last time it was compiled. TIMESTAMP is the last time it was changed.