Answer Posted / santhoshkumar

select name,salary from emp where salary=(select min(sal)
from (select distinct TOP 3(salary) from emp order by
salary desc;

Difference between open_form and call_form in oracle.

1224

---

How many categories of data types?

1043

---

What is the fastest query method to fetch data from the table?

1418

---

How to create a stored function in oracle?

1158

---

how can db_files > maxdatafiles since db_files is for instance and the later is for database

2675

---

How to start an oracle instance?

1076

---

Can I create users through internet explorer in oracle 10g?

1157

---

various types of hints and their usage

2751

---

Explain constraining triggers.

1167

---

What is literal?

1063

---

How can we find out the current date and time in oracle?

1132

---

Is insert autocommit in oracle?

1134

---

What are the differences between lov and list item?

1147

---

Explain the types of exception?

1194

---

How to check database size in Oracle?

1257

---