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

What happens in oracle commit?

0 Answers  

---

What privilege is needed for a user to create views in oracle?

0 Answers  

---

How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?

0 Answers   Zensar,

---

In my table i have 4 columns with 100 records but in that 4 columns one column contains all NULL values so can i add NOT NULL CONSTRAINT on that column......... ok if it is not possible, can i add NOT NULL CONSTRAINT from 101 Record Onwards?

4 Answers   Cap Gemini,

---

What is Data Block ?

2 Answers  

---

how to get required data from oracle source is like this ram_05_seetha lax_05_viswa bamr05frummy run_01_away sw_sas_trim i want my target data like ram_05_seetha lax_05_viswa to get data using %_05_% but it will give ram_05_seetha lax_05_viswa bamr05frummy how can i get my target data?

1 Answers   Infosys,

---

What is the effect of setting the value of OPTIMIZER_MODE to 'RULE' ?

1 Answers  

---

How to use existing values in update statements using oracle?

0 Answers  

---

What is data type in oracle?

0 Answers  

---

How to view existing locks on the database?

0 Answers  

---

Where do you use decode and case statements?

0 Answers  

---

can a table has a column that has only view data and in other columns we can change data?

2 Answers   Secon,

---