SELECT 

 (COALESCE(a.titre,'0') || ' ' || COALESCE(a.nom,'') || ' ' || COALESCE(a.prenom,'') ) as nom,
 a.marital as marital,
 to_char(a.datenaissance,'DD/MM/YYYY') as datenaissance,
 a.nature
 
FROM 

 &DB_PREFIXEautorisation a, 
 &DB_PREFIXEoperation o

WHERE 
 a.dcd is FALSE AND
 o.emplacement = a.emplacement AND
 o.operation = '&idx';