View情報

View一覧表示

# ユーザ権限

col VIEW_NAME       for a30
col VIEW_TYPE_OWNER for a20

select VIEW_NAME,VIEW_TYPE_OWNER from user_views;
select VIEW_NAME,VIEW_TYPE_OWNER from all_views;
select VIEW_NAME,VIEW_TYPE_OWNER from dba_views;


View 作成ソース

# ユーザ権限

set long 10000
select view_name,text from user_views where view_name = upper('&ビュー名');