Answer / nishi

Select rownum,empno,ename,salary from emp group by rownum,empno,ename,salary having Mod(rownum,2)=0 -- To display EVEN records.

Select rownum,empno,ename,salary from emp group by rownum,empno,ename,salary having Mod(rownum,2)=1 -- To display ODD records.

Answer / swastik mohanty

--TO FIND EVEN NUMBER
SELECT * FROM Table
WHERE ROWID IN (SELECT DECODE(MOD(ROWNUM, 2), 0, ROWID, NULL) FROM Table);
--TO FIND ODD NUMBER
SELECT * FROM Table
WHERE ROWID IN (SELECT DECODE(MOD(ROWID, 2), 1, ROWID, NULL) FROM Table);

Answer / 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

sql command 2 know current database

4 Answers  

---

What is Row Chaining ?

3 Answers   Cognizant, CTS,

---

how to clone 9i Database on to 10g Database.

0 Answers  

---

What is materialized view in Oracle?

0 Answers   MCN Solutions,

---

How are Indexes Update ?

1 Answers  

---

Why cursor variables are easier to use than cursors?

0 Answers  

---

how to store only time in a data base table

2 Answers  

---

1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE

0 Answers  

---

What happens if you set the sga too low in oracle?

0 Answers  

---

How are extents allocated to a segment?

0 Answers  

---

How do we get field details of a table?

0 Answers  

---

How many memory layers are in the shared pool?

1 Answers  

---