oracle 查询包依赖 定时任务 包失效查询 等系统相关

select * from APPLSYS.FND_APPLICATION t

--定时任务

select * from user_jobs

--失效查询
select * from all_objects
where status='INVALID' and owner <>'SYSTEM'

--查询包依赖
SELECT dd.*
  FROM dba_dependencies dd where referenced_name =upper('cux_roll_rule_pkg')
 WHERE NAME <> referenced_name
   AND referenced_type <> 'TABLE'
   AND dd.referenced_type = 'PACKAGE'
   AND dd.referenced_name LIKE '%CUX%'
   AND NAME = 'cux_roll_rule_pkg'

--ORACLE查出表所有的触发器及触发器详细信息

--一.查all_triggers表得到trigger_name

--Sql代码

select trigger_name from all_triggers where table_name='XXX';  

--二.根据trigger_name查询出触发器详细信息

--Sql代码  

select * from all_source where type='TRIGGER' AND text like '%%' ;
select * from all_source where  text like '%%' ;

SELECT dd.*
  FROM dba_dependencies dd
 WHERE NAME <> referenced_name
   AND referenced_type <> 'TABLE'
   AND dd.referenced_type = 'PACKAGE'
   AND dd.referenced_name LIKE '%CUX%'
   AND NAME = ''

转载请注明出处:

转载自http://lxfamn.cn/blog

未经允许不得转载：lxfamn » oracle 查询包依赖 定时任务 包失效查询 等系统相关