Answer Posted / shivaprasad

select distinct top 1 Salary from(select distinct top 3
Salary from Employee order by Salary DESC)temp order by
Salary;

Why does Oracle not permit the use of PCTUSED with indexes?

2480

---

why dont we assign not null constraint as table level constraint.

2798

---

What is index-organized table in Oracle?

1121

---

How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?

1970

---

Which is better Oracle or MS SQL? Why?

6487

---

Explain overloading. Can functions be overloaded?

1049

---

How to count groups returned with the group by clause in oracle?

1123

---

How to pass parameters to procedures in oracle?

1083

---

What is a initialization parameter file in oracle?

1088

---

Explain an extent?

1158

---

How to omit columns with default values in insert statement in oracle?

1099

---

How to write text literals in oracle?

1120

---

How to view the tablespaces in the current database?

1027

---

How to convert dates to characters in oracle?

1094

---

Explain the use of Merge statement in oracle 11g

1077

---