--
--  Name: views_show.sql
--
--  Description: Views - Displays text of views. Use % for all owners and/or all views.
--
--  Compatability: 7.3.x and above
--
--  Usage: @views_show owner view_name
--
--
set long 10000
select text from dba_views 
where view_name like upper('&2')
and owner like upper('&1');