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

Parameter Type Description
owner TEXT The username of the owner to which a 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 tex of the SELECT statement that defines the view.