How to merge rows from a Virtual Table, based on a foreign key

[sesh]

The following is the sample result of a large SQL SELECT Statement, from a single table. I have used --- to show the X values under each column

CODE------XX-------------YY-----------------ZZ
AD------------X-----------------------------------
AD-----------------------------------------------X
AD---------------------------X--------------------
CD------------X-----------------------------------
CD-----------------------------------------------X
CD---------------------------X--------------------

I would like to further refine the above results by merging onto a single row for each CODE. Example below.

Please note that each row for each code, will have only one value. So, using a CONCAT feature would be fine for me. I am at a loss to identify the parent SQL Statement to merge the data as below

CODE--XX--YY--ZZ
AD-------X---X---X
CD-------X---X---X

Request help from folks on this forum

[amitpatel66]

Try this:

SQL> with t as (select 'AD' col1,'X' xx,NULL yy,NULL zz from dual
  2  union select 'AD',NULL,NULL,'X' from dual
  3  union select 'AD',NULL,'X',NULL from dual
  4  union select 'CD','X',NULL,NULL from dual
  5  union select 'CD',NULL,'X',NULL from dual)
  6  SELECT col1,MAX(xx),MAX(yy),MAX(zz) FROM t
  7  GROUP BY col1;
 
CO M M M
-- - - -
AD X X X
CD X X
 
SQL>