How to find 1st, 2nd, 3rd highest using select select statement not using rownum

2 Answers  

---

why you need store procedure ? where do we use it in a Java project? can you get the code for as store procedure using in Java?

1 Answers   Goldman Sachs,

---

Is it possible to join two tables, that are in two different users (e.g. SCOTT and HR etc.),but im same database (e.g. ORCL)? If yes, then how it is possible? Explain with step by step procedure.

1 Answers   IBM,

---

What is Partitions in Table ?

2 Answers   Atiric Software,

---

Is rowid unique in oracle?

0 Answers  

---

---

Hi all, Can any one give answer for this question. Suppose im having employee table with fields, eno, ename, dept, address1, address2, address3. In address field employee can fill only address1 or address2 or address3... at a time he can fill three address fields. now i want all employee names who filled only one address field.. Plz its urjent can any one give querry.. Thanks in advance.

4 Answers   JPMorgan Chase,

---

How to apply filtering criteria at group level in oracle?

0 Answers  

---

How to add a new column to an existing table in oracle?

0 Answers  

---

What is object data modeling?

0 Answers  

---

How to Truncate Table in Oracle

0 Answers   HCL,

---

difference between procedures and function?

7 Answers   IBM,

---

How to connect to a remote server?

0 Answers  

---