Answer Posted / anitha

select min(salary)
from (select distinct salary
from employee
order by salary desc)
where rownum <= 2

What is the difference between truncate & delete command?

1125

---

What are the built-in functions used for sending Parameters to forms ?

3310

---

types of indexes and the rationale behind choosing a particular index for a situation.

2448

---

What is a sub query? What are its various types?

1082

---

How to start a new transaction in oracle?

1018

---

Difference between open_form and call_form in oracle.

1094

---

How to create an oracle testing table?

1011

---

What will be the syntax to find current date and time in format "yyyy-mm-dd"?

970

---

Hi friends can u send the oracle 9i full version download link?????????????? please reply ?

1817

---

What is the difference between post-database commit and post-form commit?

1110

---

How to export data with a field delimiter?

974

---

Why use resource manager in Oracle?

1055

---

What is instant client oracle?

974

---

How to load data from external tables to regular tables?

991

---

How many types of synonyms in Oracle?

1069

---