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

List out the types of joins.

0 Answers  

---

How do you bind variables in oracle?

0 Answers  

---

What are the trigger associated with image items ?

1 Answers   Oracle,

---

ABOUT IDENTITY?

0 Answers   HCL,

---

What is connection pooling in oracle?

0 Answers  

---

How to assign values to data fields in record variables?

0 Answers  

---

In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?

1 Answers  

---

What are ACID properties in databases?

1 Answers  

---

Explain what are the characteristics of data files?

0 Answers  

---

How to convert characters to numbers in oracle?

0 Answers  

---

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

0 Answers  

---

Can you create a synonym without having a table?

0 Answers  

---