Oracle 11g Release 2

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table test (po number, pr number, ireq number);
insert into test values (1,3,1);
1 rows affected

insert into test values (2,1,0);
1 rows affected

insert into test values (1,0,1);
1 rows affected

insert into test values (1,0,0);
1 rows affected

insert into test values (0,2,1);
1 rows affected

insert into test values (0,1,0);
1 rows affected

insert into test values (0,0,2);
1 rows affected

insert into test values (0,0,0);
1 rows affected

select decode(LINE_COMMENT, '', 'NO RESULTS', rtrim(LINE_COMMENT,','))  LINE_COMMENT
from (
select decode(po, 0, '', TO_CHAR(po) || ' PO,') 
       || decode(pr, 0, '', TO_CHAR(pR) || ' PR,') 
       || decode(ireq, 0, '', TO_CHAR(ireq) || ' IREQ') LINE_COMMENT
from test);


LINE_COMMENT


1 PO,3 PR,1 IREQ

2 PO,1 PR

1 PO,1 IREQ

1 PO

2 PR,1 IREQ

1 PR

2 IREQ

NO RESULTS