Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- REPLACE(TO_CHAR(VV.VALOR, 'FM999,999,999')
- , ',', '.')
- FROM
- BI_T_INDICADOR_VALOR VV
- LEFT JOIN BI_T_DIMENSION DD ON (VV.ID_DIMENSION1 = DD.ID_DIMENSION)
- WHERE
- ID_INDICADOR = 'COM001'
- AND ID_TIPO_SECCION = 0
- AND ID_TIPO_TEMPORAL = :ID_TIPO_TEMPORAL
- AND ID_DIA = (SELECT LEAST(FECHA_PUBLICACION, TO_DATE(:ID_DIA, 'dd/mm/yyyy')) FROM BI_T_INDICADOR WHERE ID_INDICADOR = 'COM001')
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement