select * from all_views;

select text from all_views;    --查看view的建立sql

 

--查看oracle版本

select * from v$version

 

--查看表结构
desc tableName;