anubina

Los cursores están muy penalizados por el consumo de memoria, sobre todo para cuando se poseen muchos registros, por ello te propongo la siguiente consulta with -- Consulta del punto 1 Clientes as ( select cliente from t_clientes ) -- Consultas del...

-- < Ora10g WITH dias as ( select '01' as dia from dual union select '02' as dia from dual union select '03' as dia from dual union select '04' as dia from dual union select '05' as dia from dual union select '06' as dia from dual union select '07'...

trunc(campo_fecha) = trunc(SYSDATE) Campo_fecha es el campo de tipo DATE de la tabla