Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ALTER SESSION SET nls_date_format = 'DD/MM/YYYY';
- SELECT edi.edi_nombre_edificio "Edificio", co.nombre_comuna "Comuna",
- substr(adm.ADM_NUMRUN,1,2)||'.'||substr(adm.ADM_NUMRUN,3,3)||'.'||substr(adm.ADM_NUMRUN,6,3)||'-'||adm.ADM_DVRUN "RUN",
- initcap(adm.ADM_PNOMBRE)||' '||initcap(adm.ADM_SNOMBRE)||' '||initcap(adm.ADM_APELLIDO_PATERNO)||' '||initcap(adm.ADM_APELLIDO_MATERNO) AS "Nombre Administrador"
- FROM edificio edi JOIN comuna co
- ON (edi.id_comuna = co.id_comuna)
- JOIN administrador adm
- ON (edi.adm_numrun = adm.adm_numrun)
- JOIN departamento dep
- ON (dep.id_edificio = edi.id_edificio);
- --group by dep.id_edificio
- --where (add_months(current_date,-1)) = last_day(current_date);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement