UN pivot

ps
или
select p,decode(p,'ID',id,'NAME', name,'VALUES',values) v
from t,(select 'ID' p from dual union all select 'NAME' p from dual union all select 'VALUE' p from dual) u

....
stax