亚洲AV无码乱码在线观看不卡|最新大伊香蕉精品视频在线|亚洲不卡av一区二区|国产美女无遮挡免费

    5、視圖

            查看視圖的名稱
            SQL>select view_name from user_views;

            查看創(chuàng)建視圖的select語句
            SQL>set view_name,text_length from user_views;
            SQL>set long 2000;                說明：可以根據(jù)視圖的text_length值設(shè)定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、存儲函數(shù)和過程

            查看函數(shù)和過程的狀態(tài)
            SQL>select object_name,status from user_objects where object_type='FUNCTION';
            SQL>select object_name,status from user_objects where object_type='PROCEDURE';

            查看函數(shù)和過程的源代碼
            SQL>select text from all_source where owner=user and name=upper('&plsql_name');

三、查看數(shù)據(jù)庫的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