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(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

null