By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
with example_table( id, src_approval,dst_approval ) as
(
select 62614, 'OK', 'OK' from dual union all
select 62615, 'OK', 'Rejected' from dual
)
select colvalue from
(
select id, colvalue, col
from example_table
unpivot(colvalue for col in(src_approval,dst_approval))
)
where id = 62615
| COLVALUE |
|---|
| OK |
| Rejected |