
SELECT
  (nom||' '||marital||' '||prenom) as nom,
  to_char(datenaissance,'DD/MM/YYYY') as naissance,
  to_char(dateinhumation,'DD/MM/YYYY') as dateinhumation,
  nature,
  taille,
  reduction,
  exhumation

FROM
  &DB_PREFIXEdefunt_archive

WHERE
  emplacement=&idx
;
