select dv.owner, dv.view_name, xxen_xdo.view_sql(dv.view_name,dv.owner) view_sql, dv.text_vc from dba_views dv where 1=1 |
select dv.owner, dv.view_name, xxen_xdo.view_sql(dv.view_name,dv.owner) view_sql, dv.text_vc from dba_views dv where 1=1
| Parameter Name | SQL text | Validation | |
|---|---|---|---|
| Owner |
dv.owner=:owner | LOV | |
| View Name |
dv.view_name=:view_name | LOV |
Blitz Report™ provides multiple benefits: