Saya menjalankan query ini :
select
cluster_name,Orig_GT,
Machine_NO, description, attempt, delivered, lt10, lt20,
lt1h, ge1h,undelivered, overflow,
delivered/(attempt-overflow) delivery_rate,
lt10/(attempt-overflow) delivery_rate_lt10
from (
select
s.cluster_name,
getOperator(s.clgflag) Orig_GT,
getMachine(s.cldflag) Machine_NO,
t.DESCRIPTION description,
sum(decode(s.parameter_value,'attempt',value,0)) attempt,
sum(decode(s.parameter_value,'delivered',value,0)) delivered,
sum(decode(s.parameter_value,'lt10',value,0)) lt10,
sum(decode(s.parameter_value,'lt20',value,0)) lt20,
sum(decode(s.parameter_value,'lt1h',value,0)) lt1h,
sum(decode(s.parameter_value,'ge1h',value,0)) ge1h,
sum(decode(s.parameter_value,'C1',value,'C2',value,'C3',value,'C4',value,'C8',value,'C30',value,'C32',value,'C36',value,'C37',value,'C38',value,'C39',value,0))
undelivered,
sum(decode(s.parameter_value,'C20',value,'C21',value,'C22',value,'C23',value,'C24',value,'C25',value,'C26',value,'C27',value,'C28',value,'C29',value,0))
overflow
FROM SMSAPP.SUMMARY_HOURLY_TODAY2 s,
SMSAPP.TOPUP t
where getMachine(s.cldflag) not like 'Person'
and ltrim(s.cldflag,'MN ') = t.prefix (+)
group by
grouping sets ((s.cluster_name,getOperator(s.clgflag),getMachine(s.cldflag
)),(t.DESCRIPTION))
order by s.cluster_name asc,t.DESCRIPTION)
where attempt > overflow
dan data keluar sesuai dengan yang saya inginkan.
tetapi ketika saya memasukkan query tersebut ke dalam view, dan menjalankan
view tersebut (select * from view_machine), muncul error : ORA-03001:
unimplemented feature
Kira-kira, kenapa hal tersebut terjadi ?
[Non-text portions of this message have been removed]
