CONSULTA:
select trim(case when to_char(current_date,'d') = '1' then 'DOMINGO'
when to_char(current_date,'d') = '2' then 'LUNES'
when to_char(current_date,'d') = '3' then 'MARTES'
when to_char(current_date,'d') = '4' then 'MIERCOLES'
when to_char(current_date,'d') = '5' then 'JUEVES'
when to_char(current_date,'d') = '6' then 'VIERNES'
when to_char(current_date,'d') = '7' then 'SABADO'
end)||' '|| to_char(current_date,'dd')||' '||trim(case when
to_char(current_date,'mm') = '01' then 'ENERO'
when to_char(current_date,'mm') = '02' then 'FEBRERO'
when to_char(current_date,'mm') = '03' then 'MARZO'
when to_char(current_date,'mm') = '04' then 'ABRIL'
when to_char(current_date,'mm') = '05' then 'MAYO'
when to_char(current_date,'mm') = '06' then 'JUNIO'
when to_char(current_date,'mm') = '07' then 'JULI0'
when to_char(current_date,'mm') = '08' then 'AGOSTO'
when to_char(current_date,'mm') = '09' then 'SETIEMBRE'
when to_char(current_date,'mm') = '10' then 'OCTUBRE'
when to_char(current_date,'mm') = '11' then 'NOVIEMBRE'
when to_char(current_date,'mm') = '12' then 'DICIEMBRE'
end)||' DEL '||trim(to_char(current_date,'yyyy'))
--------------------------------------------------------------------------------------------------------------
