5、视图

            查看视图的名称
            SQL>select view_name from user_views;

            查看创建视图的select语句
            SQL>set view_name,text_length from user_views;
            SQL>set long 2000;                说明：可以根据视图的text_length值设定set long 的大小
            SQL>select text from user_views where view_name=upper('&view_name');

    6、同义词

            查看同义词的名称
            SQL>select * from user_synonyms;

    7、约束条件

            查看某表的约束条件
            SQL>select constraint_name, constraint_type,search_condition, r_constraint_name
                from user_constraints where table_name = upper('&table_name');

        SQL>select c.constraint_name,c.constraint_type,cc.column_name
            from user_constraints c,user_cons_columns cc
            where c.owner = upper('&table_owner') and c.table_name = upper('&table_name')
            and c.owner = cc.owner and c.constraint_name = cc.constraint_name
            order by cc.position;

    8、存储函数和过程

            查看函数和过程的状态
            SQL>select object_name,status from user_objects where object_type='FUNCTION';
            SQL>select object_name,status from user_objects where object_type='PROCEDURE';

            查看函数和过程的源代码
            SQL>select text from all_source where owner=user and name=upper('&plsql_name');

三、查看数据库的SQL
1、查看表空间的名称及大小

    select t.tablespace_name, round(sum(bytes/(1024*1024)),0) ts_size
    from dba_tablespaces t, dba_data_files d
    where t.tablespace_name = d.tablespace_name