Answer Posted / shareef
select * from emp where (rowid,0) in(select rowid,mod(rownum,2) from emp);---even
select * from emp where (rowid,1) in(select rowid,mod(rownum,2) from emp);---odd
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Is there an oracle sql query that aggregates multiple rows into one row?
What is the difference between a user and a schema in oracle?
How to create a new user account in oracle?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
Is the After report trigger fired if the report execution fails ?
How to best split csv strings in oracle 9i?
Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?
What is meant by an index?
What to do if the startbd.bat failed to start the xe instance?
What are the differences between primary key and unique key?
how do u setup a replication site?
How to invoke the original export import utilities?
What is oracle database 10g express edition?
Name the various constraints used in oracle?
