Halimdba

Halim is a Sr. Database Engineer/Data Architect (in Atlanta, USA) who is an Oracle certified (OCP) DBA, (OCP) Developer, Certified Cloud Architect Professional as well as OCI Autonomous DB specialist with extensive expertise in Database design, configuration, tuning, capacity planning, RAC, DG, Scripting, Python, PL/SQL etc. He achieved 16th position in worldwide first-ever PL/SQL Challenge cup playoff- http://plsql-challenge.blogspot.com/2010/07/winners-of-first-plsql-challenge.html

Monday, October 12, 2009

odd and even row number

select * from emp where (rowid,1) in (select rowid,mod(rownum,2) from emp )

select * from emp where (rowid,0) in (select rowid,mod(rownum,2) from emp )

Halimdba

Monday, October 12, 2009

odd and even row number

No comments:

My Blog List