3.9 ALL_OBJECTS

Table of Contents Previous Next


3 Oracle Catalog Views : 3.9 ALL_OBJECTS

The ALL_OBJECTS view provides information about all objects that reside in the database.
Type of the object – possible values are: INDEX, FUNCTION, PACKAGE, PACKAGE BODY, PROCEDURE, SEQUENCE, SYNONYM, TABLE, TRIGGER, and VIEW.
Y if a temporary object; N if this is a permanent object.

3 Oracle Catalog Views : 3.9 ALL_OBJECTS

Table of Contents Previous Next