DBA_VIEWS v16

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

NameTypeDescription
ownerTEXTUser name of the view owner.
schema_nameTEXTName of the schema in which the view belongs.
view_nameTEXTName of the view.
textTEXTText of the SELECT statement that defines the view.