Interested to Buy Any Domain ? << Click Here >> for more details...
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
Who developed oracle & when?
How to run create database statement?
How to create a stored program unit?
What happens to the current transaction if the session is killed?
How to end the current transaction in oracle?
What is system global area (sga) in oracle?
What is Undo Management Advisor in Oracle?
How to load a large xml file?
Where do you use decode and case statements?
How to assign values to data fields in record variables?
How to write date and time interval literals in oracle?
How to export data with a field delimiter?
candidate key is subset of super key but not vice-verse explain
What is the max number of columns in an oracle table?
How to get last row id?
