查询视图sql

1：Oracle

select text from all_views where view_name = '视图名字';

2:SQL

select text from syscomments s1 join sysobjects s2 on s1.id=s2.id where name='视图名字'