如何Oracle 中取得 view、Materialized View、synonyms的相关信息

select * from dba_tab_columns where table_name in (select view_name from user_views) 51Testing软件测试网*~*L ~X$UL&q&MAF.o*L
select * from dba_tab_columns where table_name in (select view_name from all_views)
2FC%D#I^DqK\0
0z MBqAe0
` D;mS!kYp0select * from dba_tab_columns where table_name in (select mview_name from user_mviews)
y3HRT^9C0select * from dba_tab_columns where table_name in (select mview_name from all_mviews) 51Testing软件测试网b/Y0@;B8Q(p;C
51Testing软件测试网1D In/u x{"G~,B
51Testing软件测试网G` `'Ty6]
select * from dba_tab_columns where table_name in (select table_name from user_synonyms) 51Testing软件测试网ka`nZ8\s1jv
select * from dba_tab_columns where table_name in (select table_name from all_synonyms)