ORACLE check view

select owner as schema_name,

       view_name

from sys.all_views where VIEW_NAME like 'P%'

order by owner,

         view_name;