59
Hello All,
I want to get the number/count of views present in the schema
You can use system view VIEWS for that.
For instance with following statement you get the number of views per schema in your system:
select schema_name, count(*) as no_of_views from views group by schema_name;