SQL & PL/SQL

Hi,

Under Oracle Database 19c Enterprise Edition Release 19.0.0.0.0, , for an application Oracle APEX, I have to make a select list with two columns returned and with an alias for each one, the first alias is “R”, the second is “D”. The select is :

select statut_contact R FROM CS_CONTACT, 
(select case 
          when statut_contact = 0 then 'A contacter'
          when statut_contact = 3 then 'Contacté'  
          when statut_contact = 5 then 'En attente de réponse'  
          when statut_contact = 2 then 'Relance à faire'             
      end as statut
 from CS_CONTACT) "D"

It only returns the alias “R”, not the alias “D”.

This is the DDL of the table :

  CREATE TABLE "CS_CONTACT" 
  (    "ID" NUMBER GENERATED BY DEFAULT ON NULL AS IDENTITY MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE  NOKEEP  NOSCALE  NOT NULL ENABLE, 
    "PRÉNOM" VARCHAR2(128 CHAR), 
    "NOM" VARCHAR2(128 CHAR), 
    "FONCTION" VARCHAR2(128 CHAR), 
    "EMAIL" VARCHAR2(128 CHAR), 
    "TÉLÉPHONE" VARCHAR2(128 CHAR), 
    "LINKEDIN" VARCHAR2(128 CHAR), 
    "ENTREPRISE" NUMBER, 
    "CREE_LE" DATE, 
    "DATE_DECISION" DATE, 
    "CONTACT_INTERNE" NUMBER, 
    "COMMENTAIRES" VARCHAR2(512), 
    "ROLE" VARCHAR2(96), 
    "PRIORITE_CONTACT" VARCHAR2(96), 
    "RELATION" VARCHAR2(69), 
    "SCORE_CONTACT" NUMBER, 
    "STATUT_CONTACT" NUMBER, 
    "DATE_PROCHAINE_ACTION" DATE, 
     CONSTRAINT "CS_CONTACT_PK" PRIMARY KEY ("ID")
 USING INDEX  ENABLE
  ) ;

Example of data:

INSERT INTO CS_CONTACT (ID,PRÉNOM,NOM,FONCTION,EMAIL,TÉLÉPHONE,LINKEDIN,ENTREPRISE,CREE_LE,DATE_DECISION,CONTACT_INTERNE,COMMENTAIRES,ROLE,PRIORITE_CONTACT,RELATION,SCORE_CONTACT,STATUT_CONTACT,DATE_PROCHAINE_ACTION) VALUES (26,'Christian','DUPONT','Dév','cpitet2@gmail.com',NULL,NULL,2166,'2026-06-04',NULL,NULL,NULL,'Décideur','Haute','Très chaud',17.5,0,'2026-06-04');
INSERT INTO CS_CONTACT (ID,PRÉNOM,NOM,FONCTION,EMAIL,TÉLÉPHONE,LINKEDIN,ENTREPRISE,CREE_LE,DATE_DECISION,CONTACT_INTERNE,COMMENTAIRES,ROLE,PRIORITE_CONTACT,RELATION,SCORE_CONTACT,STATUT_CONTACT,DATE_PROCHAINE_ACTION) VALUES (25,'Christian','DELVAL','dev','xxxxxt@gmail.com',0952187872,NULL,2915,'2026-06-04',NULL,1,NULL,'Prescripteur','Haute','Très chaud',13.5,5,'2026-11-04');

In this example, it should return D as ‘A contacter’ for Statut du contact = 0, and ‘En attente de réponse’ for Statut du Contact = 5.

Best regards.