SELECT  'Commune &commune'||' '||'Dossier '||dossier as dossier,
to_char(date_depot,'DD/MM/YYYY') as date_depot,
COALESCE(demandeur_civilite,'sans')||' '||demandeur_nom as nom_demandeur,
terrain_numero||' '||terrain_numero_complement||' '||terrain_adresse||' '||terrain_adresse_complement||'
 '||terrain_cp||'  '||terrain_ville as adresse_terrain, 
shon, 
logement_nombre as nb_logt
from dossier
 where dossier.nature='&nature' AND (date_depot>='&datedebut'
 AND date_depot<='&datefin')
ORDER BY dossier