Hi guys

I m ALI an oracle developer from Pakistan

for odd records:

[sql]SELECT * FROM emp WHERE ROWID IN ( SELECT DECODE(MOD(ROWNUM,2),1,ROWID) FROM emp );[/sql]


for even;

[sql] SELECT * FROM emp WHERE ROWID IN ( SELECT DECODE(MOD(ROWNUM,2),0,ROWID) FROM emp );[/sql]


try this hope problem will b solved


thanks

remeber me in pray