USER_OBJECTS v16

The USER_OBJECTS view provides information about all objects that are owned by the current user.

NameTypeDescription
schema_nameTEXTName of the schema in which the object belongs.
object_nameTEXTName of the object.
object_typeTEXTType of the object. Possible values are: INDEX, FUNCTION, PACKAGE, PACKAGE BODY, PROCEDURE, SEQUENCE, SYNONYM, TABLE, TRIGGER, and VIEW.
createdDATETimestamp for the creation of an object.
last_ddl_timeDATETimestamp for the last modification of an object resulting from a DDL statement including grants and revokes.
statusCHARACTER VARYINGIncluded only for compatibility. Always set to VALID.
temporaryTEXTY if the object is temporary; N if the object isn't temporary.