1 2 3 4 5 6 7 8 9 10 11 12 13
| SELECT TACTAC_PLA_CODE, TRT_CODE, TRT_DESI,
AVG(round(to_number(EXE_DT_FIN - EXE_DT_DEM)*1440)) as AVERAGE
FROM BASEQ.BQ_TRAITEMENT, BASEQ.BQ_TAC_TAC, BASEQ.BQ_EXECUTION
WHERE TRT_CODE = TACTAC_TRT_CODE AND EXE_TAC_TRT_CODE = TRT_CODE AND TRT_INT_IDENT_LR='O' AND EXE_TAC_TRT_CODE = TRT_CODE AND EXE_TAC_TRT_CODE = TRT_CODE
GROUP BY EXE_TAC_TRT_CODE,TACTAC_PLA_CODE, TRT_CODE, TRT_DESI,EXE_DT_FIN , EXE_DT_DEM
SELECT TACTAC_PLA_CODE, TRT_CODE, TRT_DESI,
(round(to_number(EXE_DT_FIN - EXE_DT_DEM)*1440)) AS DUREE,
FROM BASEQ.BQ_TRAITEMENT, BASEQ.BQ_TAC_TAC, BASEQ.BQ_EXECUTION
WHERE TRT_CODE = TACTAC_TRT_CODE AND EXE_TAC_TRT_CODE = TRT_CODE AND TRT_INT_IDENT_LR='O' AND EXE_TAC_TRT_CODE = TRT_CODE AND EXE_TAC_TRT_CODE = TRT_CODE AND EXE_DT_DEM > SYSDATE-1
GROUP BY EXE_TAC_TRT_CODE,TACTAC_PLA_CODE, TRT_CODE, TRT_DESI,EXE_DT_FIN , EXE_DT_DEM |
Partager