select * from ( select to_char(hiredate,'mm') aaa,t.* from emp t ) where aaa=12
select * from ( select rownum num,t.* from emp t ) where num=12
select * from ( select to_char(hiredate,'mm') aaa,t.* from emp t ) where aaa=12
select * from ( select rownum num,t.* from emp t ) where num=12