--查看用户下所有的表select * from user_tables;--查看用户下所有的表的列属性select * from USER_TAB_COLUMNS where table_name=upper(':table_name');--查看某表的创建时间select object_name,created from user_objects where object_name=upper(':table_name');--查看某表的大小select sum(bytes)/(1024*1024) as "size(M)" from user_segments where segment_name=upper(':table_name');--查看所有视图名称及创建视图的select语句select view_name,text from user_views;--查看函数和过程等的源代码select * from user_source --查看表注释select * from user_tab_comments where table_name=upper(':table_name');--查看表的字段的注释select * from user_col_comments where table_name=upper(':table_name');