
SELECT
  (nom||' '||prenom) as ayantdroit,
  (adresse1||' '||cp||' '||ville) as adresse,
  to_char(datenaissance,'DD/MM/YYYY') as datenaissance  

FROM
  &DB_PREFIXEautorisation 

WHERE
  emplacement=&idx
  AND nature='ayantdroit'
;
