SELECT 

 (COALESCE(defunt_titre,'0') || ' ' || COALESCE(defunt_nom,'') || ' ' || COALESCE(defunt_prenom,'') || ' (' || COALESCE(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';