SQL & PL/SQL

Hi,

Under Oracle 19c, I have a select:

SELECT max(cih.date_action_effectuee) AS max_date,  min(cih.date_action_effectuee) AS min_date,
      cih.id_interaction,
      cih.type_interaction, 
      ce.entreprises || ' ' || cih.type_interaction AS display
 FROM cs_interaction_historique cih
 LEFT JOIN cs_entreprise ce
   ON cih.entreprise = ce.id
GROUP BY cih.id_interaction,
         cih.type_interaction,
         ce.entreprises

I ge this result:

But the cih.type_interaction is not diplayed in the column “display”when I run the select. “chit.type_interaction” contains data as you can see.

I would like that that the column DISPLAY displays TYPE_INTERACTION.

Best regards.