CREATE OR REPLACE PROCEDURE P_GCELL_PEAK_ZTE(I_RECDATE IN VARCHAR) AS
V_EXIST INT;
V_RECDATE DATE := TO_DATE(I_RECDATE, 'YYYY-MM-DD');
MY_BREAK EXCEPTION;
BEGIN
SELECT COUNT(1)
INTO V_EXIST
FROM A_BASIC_CS_RADIO_H
WHERE COLLECTTIME BETWEEN V_RECDATE AND V_RECDATE + 23 / 24;
IF V_EXIST = 0 THEN
RAISE MY_BREAK;
ELSE
DBMS_OUTPUT.PUT_LINE('A_BASIC_CS_RADIO_H 记录:' || V_EXIST);
END IF;
EXECUTE IMMEDIATE 'TRUNCATE TABLE GCELL_PEAK_TEMPZTETCH';
INSERT INTO GCELL_PEAK_TEMPZTETCH
SELECT BSCID, SITEID, BTSID, COLLECTTIME, TRAFFIC_TCH
FROM (SELECT BSCID,
SITEID,
BTSID,
COLLECTTIME,
(C100030127 + C100030129) / 3600 TRAFFIC_TCH,
ROW_NUMBER() OVER(PARTITION BY BSCID, SITEID, BTSID ORDER BY(C100030127 + C100030129) DESC) RN
FROM A_BASIC_CS_RADIO_H
WHERE COLLECTTIME BETWEEN V_RECDATE AND V_RECDATE + 23 / 24)
WHERE RN = 1;
COMMIT;
SELECT COUNT(1) INTO V_EXIST FROM GCELL_PEAK_TEMPZTETCH;
DBMS_OUTPUT.PUT_LINE('GCELL_PEAK_TEMPZTETCH TCH忙时已经汇总:' || V_EXIST);
EXECUTE IMMEDIATE 'TRUNCATE TABLE GCELL_PEAK_TEMPZTESD';
INSERT INTO GCELL_PEAK_TEMPZTESD
SELECT BSCID, SITEID, BTSID, COLLECTTIME, TRAFFIC_SD
FROM (SELECT BSCID,
SITEID,
BTSID,
COLLECTTIME,
C100030124 / 3600 TRAFFIC_SD,
ROW_NUMBER() OVER(PARTITION BY BSCID, SITEID, BTSID ORDER BY C100030124 DESC) RN
FROM A_BASIC_CS_RADIO_H
WHERE COLLECTTIME BETWEEN V_RECDATE AND V_RECDATE + 23 / 24)
WHERE RN = 1;
COMMIT;
SELECT COUNT(1) INTO V_EXIST FROM GCELL_PEAK_TEMPZTESD;
DBMS_OUTPUT.PUT_LINE('GCELL_PEAK_TEMPZTESD SD忙时已经汇总:' || V_EXIST);
EXCEPTION
WHEN MY_BREAK THEN
DBMS_OUTPUT.PUT_LINE('A_BASIC_CS_RADIO_H 没有记录');
END;
分享到:
相关推荐
163 = RGSTRDDLVRY_ERR : ZTE_EXTENED Registered_Delivery取值错误 164 = FEEUSERTYPE_ERR : ZTE_EXTENED FeeUserType取值错误 165 = TERMINALTYPE_ERR : ZTE_EXTENED TerminalType取值错误 166 = MSGFMT_...
ZTE_STB_Tools_V1.1.0_T03
ZTE_Develop_Driver.exe 中兴GD115 GD116相关驱动 LTE 4G ZTE_Develop_Driver.exe 中兴GD115 GD116相关驱动 LTE 4G
1.5.2 记录数据存储方式 22 1.5.3 传送方式 22 1.5.4 数据分析 23 1.6 TRIGGER 23 1.7 TELNET 24 1.8 调试模式 24 1.8.1 任务调试模式下的多任务调试 26 1.8.2 系统调试模式下多任务的调试: 27 1.8.3 中断服务程序...
ZTE_LTE_Datacard_Product_USB_Driver ZTE_LTE_Datacard_Product_USB_Driver
ZTE_STB_Tools_V1.1.0_T07
中兴机顶盒最新现场配置工具ZTE_STB_Tools_V1.1.0_T07.01 支持最新加密版本
ZTE_eReader_3.09.210510_lite
ZTE_StbManTool_v7.4.25_B700V5S1
ZTE_Handset_USB_Driver.rar手机驱动
中兴IPTV机顶盒破解调试工具ZTE_Stb7.58破解工具。 注意:注册码极为注册时的软件机器码,请直接复制机器码到注册吗窗口注册
中兴机顶盒工具可以连接机顶盒,开启ADB和telnet.
ZTE_STB_Tools_V2.0.0_T
中兴机顶盒最新版本的现场配置工具ZTE_STB_Tools_V1.1.0_T07.01,本版本支持最新加密版本。具有查看连接和信息、媒体播放、控制台、日志管理、远程白饭、抓屏幕工具、配置工具、ADB命令控制台等功能。DesSecretKey....
Lessons from Huawei v. ZTE1
QC_ZTE_Collaboration_ULIC_Final_7_5
ZTE Corporation is a global technology company which provides telecommunications equipment
AndroidPCSync_ZTE_V7.0.1_Beta1
ZTE V889D REcovery driver 驱动刷机 必备
ZTE_STB_Tools_V1.1.0_T03 .zip