9.3. USER_OBJECTS
The USER_OBJECTS view provides status information on objects you create. This includes tables, sequences, views, stored procedures, database links, and others. The following is a partial description of columns from this view. Use this view to determine if a stored procedure is valid, if you need to recompile it, or to determine its last compile timestamp.
Refer to Chapter 5 for a complete description of the differences between the USER, ALL, and DBA data dictionary views.
USER_OBJECTS provides information only on those objects you have created in your account.
ALL_OBJECTS provides information on objects you have created plus objects to which you have privileges.
DBA_OBJECTS provides information on all objects in the database. ...
Get Programming Oracle® Triggers and Stored Procedures, Third Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
