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 is the use of composite key constraint?

2 Answers  

---

Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.

0 Answers  

---

Briefly explain what is literal? Give an example where it can be used?

0 Answers  

---

how to get last monday of a month?

2 Answers   Multifonds,

---

What is sharded cluster?

0 Answers  

---

why dont we assign not null constraint as table level constraint.

0 Answers  

---

What is the difference between sharding and replication?

0 Answers  

---

What is blob data type in oracle?

0 Answers  

---

What are the composite date types in oracle?

6 Answers   HCL,

---

Why does oracle 9i treat an empty string as null?

0 Answers  

---

We are using Oracle apps with XML publisher.In that,we are facing some problems while giving a Footer in RTF Template.While giving a footer in RTF Template it is Visible in all the pages,but after the PDF is getiing generated,the Footer are Visible on alternate pages only (like on first page ,third page) and so on. Please provide the Solution for getting the Footer on all the pages.

0 Answers  

---

What are the various oracle database objects?

0 Answers  

---