SQL & PL/SQL

Hello,

I am using oracle 19c.

Below the same data and sample expected result. Basically i need to check if the MFR_TYPE_ID count > then 1 then print "Multiple and have the MFR_NAME as comma delimited. If the MFR_TYPE_ID count = then 1 then print “Single and have the MFR_NAME as comma delimited. How to achieve this result? can this be implemented without group by? please show me a sample query to achieve this result.

WITH
    Data (MFR_TYPE_ID, MFR_NAME)
    AS
        (SELECT '100-1234', 'Apple' FROM DUAL
         UNION ALL
         SELECT '100-1234', 'Nokia' FROM DUAL
         UNION ALL
         SELECT '100-1244', 'Samsung' FROM DUAL
         UNION ALL
         SELECT '100-1245', 'Facebook' FROM DUAL
         UNION ALL
         SELECT '100-1245', 'Microsoft' FROM DUAL
         UNION ALL
         SELECT '100-1245', 'DELL' FROM DUAL)
SELECT *
  FROM Data;


--- Expected Result 
WITH
    RESULT (MFR_TYPE, MFR_NAME)
    AS
        (SELECT 'Multiple', 'Apple,Nokia' FROM DUAL
         UNION ALL
         SELECT 'Single', 'Samsung' FROM DUAL
         UNION ALL
         SELECT 'Multiple', 'Facebook,Microsoft,DELL' FROM DUAL)
SELECT MFR_TYPE, MFR_NAME
  FROM Result;