用语句查看视图

1.查看所有视图的名字

select object_name from user_objects where object_type='VIEW'

2.查看某个视图的构造语句

select text from user_views where view_name='VIEW_NAME'