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
Difference between pre-select and pre-query
What is tns service name?
How can I combine multiple rows into a comma-delimited list in oracle?
How to login to the server without an instance?
How do you increase the OS limitation for open files (LINUX and/or Solaris)?
What are the limitations oracle database 10g xe?
Write a trigger example in oracle?
What is logical backup in oracle?
how to join query for one source type is oracle another source type is sql server ?
How to start a specific oracle instance?
What is a proxy object?
What is an oracle recycle bin?
Explain drop constraint oracle?
Can we use oracle pl/sql block in core java? if so how? pls get back to me .....
Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.