ALL_VIEWS v16

The ALL_VIEWS view provides information about all user-defined views.

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