Answer Posted / nishi

select rownum, empno, ename from emp where rowid in (select rowid from emp where rownum <=&upto minus select rowid from emp where rownum<&Start);

definition of cluster and non-clustered index?

3035

---

I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?

2468

---

How do I reset a sequence in oracle?

1106

---

How to load excel data sheet to oracle database

1030

---

How to find the duplicate rows count from employees table in oracle?

1098

---

What is recycle bin in Oracle?

1155

---

How to create a stored program unit?

1234

---

Does oracle charge for java?

1060

---

What are the tools for Oracle ?

1070

---

How to check the oracle tns settings?

1048

---

What is oracle update statement with inner join ?

1067

---

what's query optimization and without use of IN AND Exist can we get another way data from query

2147

---

Is postgres faster than oracle?

1047

---

How to select an oracle system id (sid)?

1065

---

What is the usage of synonyms?

1146

---