SELECT 

 (defunt_titre || ' ' || defunt_nom || ' ' || defunt_prenom || ' (' || defunt_marital || ')' ) as nom,

 to_char(defunt_datenaissance,'DD/MM/YYYY') as datenaissance,

 to_char(defunt_datedeces,'DD/MM/YYYY') as datedeces,

 defunt_lieudeces as lieudeces


FROM 

 &DB_PREFIXEoperation_defunt

WHERE 

 operation = '&idx';