WEB开发网
开发学院数据库Oracle 用户如何有效地利用Oracle数据字典 阅读

用户如何有效地利用Oracle数据字典

 2007-05-10 12:16:31 来源:WEB开发网   
核心提示: 六、同义词查看同义词的名称SQL>select * from user_synonyms;七、约束条件查看某表的约束条件SQL>select constraint_name, constraint_type,search_condition, r_constraint_name

六、同义词

查看同义词的名称

SQL>select * from user_synonyms;

七、约束条件

查看某表的约束条件

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;

八、存储函数和过程

查看函数和过程的状态

   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');

九、触发器

查看触发器

   set long 50000;
   set heading off;
   set pagesize 2000;
   select
   'create or replace trigger "' ||
       trigger_name || '"' || chr(10)||
   decode( substr( trigger_type, 1, 1 ),
       'A', 'AFTER', 'B', 'BEFORE', 'I', 'INSTEAD OF' ) ||
          chr(10) ||
   triggering_event || chr(10) ||
   'ON "' || table_owner || '"."' ||
      table_name || '"' || chr(10) ||
   decode( instr( trigger_type, 'EACH ROW' ), 0, null,
         'FOR EACH ROW' ) || chr(10) ,
   trigger_body
   from user_triggers;

上一页  1 2 3 

Tags:用户 如何 有效

编辑录入:爽爽 [复制链接] [打 印]
赞助商链接