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

Parameter Type Description
schema_name TEXT The name of the schema to which the object belongs.
object_name TEXT The name of the object.
object_type TEXT The type of the object. Valid values: INDEX, FUNCTION, PACKAGE, PACKAGE BODY, PROCEDURE, SEQUENCE, SYNONYM, TABLE, TRIGGER, and VIEW.
status CHARACTER VARYING This parameter is supported for compatibility only. The value is VALID.
temporary TEXT
  • Y: indicates the object is temporary.
  • N: indicates the object is not temporary.