Answer Posted / amit sutar

select min(salary)

from(select distinct(salary)
from employees
order by salary desc)

where rownum<=5;

Is oracle an open source?

1128

---

What is set verify off in oracle?

1160

---

How to define an external table with a text file?

1128

---

Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.

2176

---

How to pass a cursor variable to a procedure?

1160

---

Explain what are synonyms used for?

1096

---

How to convert times to characters in oracle?

1072

---

Please explain drop constraint oracle?

1160

---

What is a database schema in oracle?

1153

---

How can I see all tables in oracle?

1061

---

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

1191

---

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?

2505

---

What is oracle open database communication (odbc)?

1086

---

How to specify default values in insert statement using oracle?

1155

---

In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?

2341

---