SELECT 

 (a.titre || ' ' || a.nom || ' ' || 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';