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

Parameter Type Description
owner TEXT The username of the owner to which the view belongs.
schema_name TEXT The name of the schema to which the view belongs.
view_name TEXT The name of the view.
text TEXT The SELECT statement that defines the view.