DBA_VIEWS v12

The DBA_VIEWS view provides information about all views in the database.

NameTypeDescription
ownerTEXTUser name of the view’s owner.
schema_nameTEXTName of the schema in which the view belongs.
view_nameTEXTName of the view.
textTEXTThe text of the SELECT statement that defines the view.