EXPLAIN PLAN FOR select value from ( ( select 'a' v1, 'b' v2 from dual ) unpivot ( value for value_type in (v1,v2) ) );

select plan_table_output from table(dbms_xplan.display('plan_table',null,'BASIC ROWS'));

EXPLAIN PLAN FOR select CASE WHEN uvp.flag = 1 THEN t.v1 WHEN uvp.flag = 2 THEN t.v2 ELSE NULL END value from ( select 'a' v1, 'b' v2 from dual ) t CROSS JOIN ( SELECT 1 flag from dual UNION ALL SELECT 2 flag from dual ) uvp;

select plan_table_output from table(dbms_xplan.display('plan_table',null,'BASIC ROWS'));