The following lines contain the word 'select', 'insert', 'update' or 'delete':
select value
into utl_dir
from v$parameter
where name = 'utl_file_dir';
select distinct upper(trim(v.queue_handler)) qhandler
from (
select queue_handler
from wf_agents
where queue_handler is not null and
instr(upper(name),p_agent_name)=1
)v, user_objects uo
where uo.object_name = v.queue_handler
and uo.object_type = 'PACKAGE BODY'
and uo.status = 'VALID';
select to_char(sysdate,'DDMONYYYYHH24MISS')
into l_timestamp
from dual;
select distinct upper(trim(v.function)) function
from (
select upper(substr(we.generate_function,1,instr(we.generate_function, '.')-1)) package_name,
we.generate_function function
from wf_events we
where we.generate_function is not null and
instr(upper(we.name),p_corrid)=1
) v, user_objects uo
where uo.object_name = nvl(v.package_name,v.function) and
uo.object_type = decode(v.package_name,null,'FUNCTION','PACKAGE BODY') and
uo.status = 'VALID';
select distinct upper(trim(v.function)) function
from (
select upper(substr(wes.rule_function,1,instr(wes.rule_function, '.')-1)) package_name,
wes.rule_function function
from wf_events we,wf_event_subscriptions wes
where we.guid = wes.event_filter_guid and
instr(upper(we.name),p_corrid)=1 and
wes.rule_function is not null and
upper(wes.rule_function) not like 'WF_RULE%' and
upper(wes.rule_function) not like 'WF_XML%'
) v, user_objects uo
where uo.object_name = nvl(v.package_name,v.function) and
uo.object_type = decode(v.package_name,null,'FUNCTION','PACKAGE BODY') and
uo.status = 'VALID';
select distinct upper(trim(v.function)) function
from (
select upper(substr(wes.rule_function,1,instr(wes.rule_function, '.')-1)) package_name,
wes.rule_function function
from wf_events we,wf_event_subscriptions wes
where we.guid = wes.event_filter_guid and
wes.rule_function is not null and
(
upper(wes.rule_function) like 'WF_RULE%' or
upper(wes.rule_function) like 'WF_XML%'
)
) v, user_objects uo
where uo.object_name = nvl(v.package_name,v.function) and
uo.object_type = decode(v.package_name,null,'FUNCTION','PACKAGE BODY') and
uo.status = 'VALID';
select to_char(sysdate,'DDMONYYYYHH24MISS')
into l_timestamp
from dual;