SELECT
b.cell_id as ci
,B.NSEI NSEI
,T.BTS_ID
,SUBSTR(c.name,1,6) bsc
,to_char(a.period_start_time,'yyyymmddhh24') repdate
,sum(a.NO_RADIO_RES_AVA_UL_TBF)UlPDTCH_TBF_Rej
,sum(a.NO_RADIO_RES_AVA_DL_TBF)DLPDTCH_TBF_Rej
,sum(a.PACKET_CH_REQ)PDTCH_Request
,SUM(A.NBR_OF_UL_TBF) UL_TBF
,SUM(A.NBR_OF_DL_TBF) DL_TBF
,SUM(A.EGPRS_TBFS_UL) UL_EGPRS_TBF
,SUM(A.EGPRS_TBFS_DL) DL_EGPRS_TBF
,SUM(A.UL_EGPRS_TBF_REL_DUE_NO_RESP) UL_EGPRS_NORESP
,SUM(A.DL_EGPRS_TBF_REL_DUE_NO_RESP) DL_EGPRS_NORESP
,SUM(A.DL_8PSK_TO_GMSK_DUE_UL_GPRS) PSK_DL_GSMK
,AVG(A.AVER_EGPRS_TBFS_PER_TSL_DL) DL_TBF_PER_TSL
,SUM(UL_TBF_ESTABLISHMENT_FAILED) EST_UL
,SUM(DL_TBF_ESTABLISHMENT_FAILED)EST_DL
,sum(a.packet_ch_req) ch_req
,sum(a.packet_immed_ass_msg)immed_ass
,sum(a.packet_immed_ass_ack_msg)immed_ass_ack
---,ROUND(decode(sum
這是用在什么地方的腳本啊, 能不能簡單介紹一下啊?
|