[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select sum(cnt)
from (
select count(*) cnt
FROM ams_event_offers_vl aeo ,
ams_event_headers_all_b aeh ,
edw_local_instance inst
WHERE
aeo.event_header_id = aeh.event_header_id and aeo.event_level = 'MAIN'
and ((aeo.last_update_date > to_date('1000/01/01', 'YYYY/MM/DD'))
or
(aeh.last_update_date > to_date('1000/01/01', 'YYYY/MM/DD')))
and
aeo.last_update_date between
p_from_date and p_to_date
UNION
select count(*)
FROM ams_event_headers_vl aeh ,
edw_local_instance inst
WHERE
aeh.event_level = 'MAIN' and
aeh.last_update_date between
p_from_date and p_to_date
);
SELECT
avg(nvl(vsize(aeo.event_offer_name), 0)),
avg(nvl(vsize(aeo.event_offer_id), 0)),
avg(nvl(vsize(aeo.parent_event_offer_id), 0)),
avg(nvl(vsize(aeo.event_header_id), 0)),
avg(nvl(vsize(aeo.event_level), 0)),
avg(nvl(vsize(aeo.event_type_code), 0)),
avg(nvl(vsize(aeo.user_status_id), 0)),
avg(nvl(vsize(aeo.last_status_date), 0)),
avg(nvl(vsize(aeo.system_status_code), 0)),
avg(nvl(vsize(aeo.timezone_id), 0)),
avg(nvl(vsize(aeo.reg_waitlist_pct), 0)),
avg(nvl(vsize(aeo.reg_overbook_pct), 0)),
avg(nvl(vsize(aeo.reg_minimum_capacity), 0)),
avg(nvl(vsize(aeo.reg_maximum_capacity), 0)),
avg(nvl(vsize(aeo.reg_effective_capacity), 0)),
avg(nvl(vsize(aeo.pricelist_line_id), 0)),
avg(nvl(vsize(aeo.pricelist_header_id), 0)),
avg(nvl(vsize(aeo.owner_user_id), 0)),
avg(nvl(vsize(aeo.org_id), 0)),
avg(nvl(vsize(aeo.inventory_item_id), 0)),
avg(nvl(vsize(aeo.event_location_id), 0)),
avg(nvl(vsize(aeo.event_duration), 0)),
avg(nvl(vsize(aeo.event_delivery_method_id), 0)),
avg(nvl(vsize(aeo.coordinator_id), 0)),
avg(nvl(vsize(aeo.certification_credits), 0)),
avg(nvl(vsize(aeo.waitlist_action_type_code), 0)),
avg(nvl(vsize(aeo.stream_type_code), 0)),
avg(nvl(vsize(aeo.source_code), 0)),
avg(nvl(vsize(aeo.reg_waitlist_allowed_flag), 0)),
avg(nvl(vsize(aeo.reg_start_time), 0)),
avg(nvl(vsize(aeo.reg_required_flag), 0)),
avg(nvl(vsize(aeo.reg_overbook_allowed_flag), 0)),
avg(nvl(vsize(aeo.reg_invited_only_flag), 0)),
avg(nvl(vsize(aeo.reg_frozen_flag), 0)),
avg(nvl(vsize(aeo.reg_end_time), 0)),
avg(nvl(vsize(aeo.reg_charge_flag), 0)),
avg(nvl(vsize(aeo.priority_type_code), 0)),
avg(nvl(vsize(aeo.partner_flag), 0)),
avg(nvl(vsize(aeo.overflow_flag), 0)),
avg(nvl(vsize(aeo.event_start_date_time), 0)),
avg(nvl(vsize(aeo.event_standalone_flag), 0)),
avg(nvl(vsize(aeo.event_required_flag), 0)),
avg(nvl(vsize(aeo.event_language_code), 0)),
avg(nvl(vsize(aeo.event_full_flag), 0)),
avg(nvl(vsize(aeo.event_end_date_time), 0)),
avg(nvl(vsize(aeo.event_duration_uom_code), 0)),
avg(nvl(vsize(aeo.cert_credit_type_code), 0)),
avg(nvl(vsize(aeo.cancellation_reason_code), 0)),
avg(nvl(vsize(aeo.inbound_script_name), 0)),
avg(nvl(vsize(aeo.email), 0)),
avg(nvl(vsize(aeo.phone), 0)),
avg(nvl(vsize(aeo.url), 0)),
avg(nvl(vsize(aeo.auto_register_flag), 0)),
avg(nvl(vsize(aeo.event_venue_id), 0)),
avg(nvl(vsize(aeo.reg_start_date), 0)),
avg(nvl(vsize(aeo.reg_minimum_req_by_date), 0)),
avg(nvl(vsize(aeo.reg_end_date), 0)),
avg(nvl(vsize(aeo.event_start_date), 0)),
avg(nvl(vsize(aeo.event_end_date), 0)),
avg(nvl(vsize(aeo.event_mktg_message), 0)),
avg(nvl(vsize(aeo.event_offer_name), 0)),
avg(nvl(vsize(aeo.description), 0)),
avg(nvl(vsize(aeo.creation_date), 0))
FROM ams_event_offers_vl aeo ,
ams_event_headers_all_b aeh ,
edw_local_instance inst
WHERE
aeo.event_header_id = aeh.event_header_id and aeo.event_level = 'MAIN'
and ((aeo.last_update_date > to_date('1000/01/01', 'YYYY/MM/DD'))
or
(aeh.last_update_date > to_date('1000/01/01', 'YYYY/MM/DD')));
select
avg(nvl(vsize(INSTANCE_CODE), 0))
from EDW_LOCAL_INSTANCE ;