select 
dossier,nature.libelle as nature,
demandeur_civilite,demandeur_nom,demandeur_societe,
demandeur_adresse,demandeur_cp,demandeur_ville,
terrain_numero, terrain_adresse, terrain_cp, terrain_ville,
terrain_surface,  hauteur, shon, shob, batiment_nombre, logement_nombre,delai, 
to_char(date_depot,'DD/MM/YYYY') as date_depot,                to_char(date_notification_delai,'DD/MM/YYYY') as date_notification_delai,
to_char(date_limite,'DD/MM/YYYY') as date_limite,
to_char(date_decision,'DD/MM/YYYY') as date_decision,
travaux.libelle as travaux
from dossier inner join nature on nature.nature = dossier.nature
left join travaux on dossier.travaux=travaux.travaux
where dossier = '&destinataire'