The following lines contain the word 'select', 'insert', 'update' or 'delete':
select sum(cnt)
from (
select count(*) cnt
FROM AS_STATUSES_VL AST ,
EDW_LOCAL_INSTANCE INST
WHERE AST.OPP_FLAG = 'Y' AND AST.ENABLED_FLAG = 'Y'
and ast.last_update_date between
p_from_date and p_to_date
);
SELECT
avg(nvl(vsize(MEANING ), 0)),
avg(nvl(vsize(STATUS_CODE ), 0)),
avg(nvl(vsize(DESCRIPTION ), 0)),
avg(nvl(vsize(OPP_OPEN_STATUS_FLAG ), 0)),
avg(nvl(vsize(FORECAST_ROLLUP_FLAG ), 0))
FROM AS_STATUSES_VL AST
WHERE AST.OPP_FLAG = 'Y' AND AST.ENABLED_FLAG = 'Y'
and AST.last_update_date between
p_from_date and p_to_date;
select
avg(nvl(vsize(INSTANCE_CODE), 0))
from EDW_LOCAL_INSTANCE ;