SELECT 
numdossier as Dossier,
to_char(date,'DD/MM/YYYY') as Date_Operation,
heure as Heure_Operation,
operation.categorie as Type_Operation
FROM  &DB_PREFIXEoperation_defunt inner join &DB_PREFIXEoperation on operation.operation=operation_defunt.operation
WHERE etat = 'trt' AND defunt = &idx