用sql语句查看oracle视图创建语句:
1.查看所有视图的名字
select view_name from all_views; 或者select view_name from user_views;
2.查看某视图名为“某某视图”的创建语句
select text from all_views where view_name = '某某视图'; (注:视图一定要是大写字母)
用sql语句查看oracle视图创建语句:
1.查看所有视图的名字
select view_name from all_views; 或者select view_name from user_views;
2.查看某视图名为“某某视图”的创建语句
select text from all_views where view_name = '某某视图'; (注:视图一定要是大写字母)