...
| Code Block | ||||
|---|---|---|---|---|
| ||||
SELECT COUNT(*)
FROM EX_V_CDR
WHERE N_CDR_TYPE_ID = SYS_CONTEXT('CONST', 'CDR_TYPE_PhoneCall')
AND N_CDR_STATE_ID = SYS_CONTEXT('CONST', 'CDR_Status_Finished')
AND D_BEGIN_ACCEND >= SYSDATE - 1/24
AND (N_SUM_A IS NULL AND N_SUM_B IS NULL)
AND N_DURATION_SEC != 0; |
...