Page History

SELECT DECODE(MAX(D_BEGINLOG_CREATE), NULL, 'Never',
       TO_CHAR(MAX(D_BEGINLOG_CREATE), 'YYYY-MM-DDDD.MM.YYYY HH24:MI:SS')) Last_Date_Load
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'(SELECT MAX(N_CDR_ID)
FROM   EX_V_CDR);

LAST_DATE_LOAD
-------------------
2013-01-2929.01.2013 11:05:54

SELECT DECODE(TO_CHAR(((SYSDATE-MAX(D_BEGIN))*(86400)), 'FM99999999999999990'), LOG_CREATE), NULL, -1,
		        TO_CHAR(((SYSDATE-MAX(D_BEGINLOG_CREATE))*(86400)), 'FM99999999999999990')) SEC
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'(SELECT MAX(N_CDR_ID)
FROM   EX_V_CDR);