Explain Plan(Transformed Query)

[dhar_kiran]

Is it possible to find out the query transformed by optimizer, that generates the best plan.

e.g:- select * from emp
where empno ='E001' or job ='CLERK'

if transformed into
select * from emp where empno='E001'
union all
select * from emp where job='CLERK' and empno <> 'E001'

How to find out transformed query, like is there any view?