Answer Posted / shivaprasad

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

What is the difference between "as" and "is" in an oracle stored procedure?

987

---

How many memory layers are in the oracle shared pool?

1177

---

What is format trigger?

2066

---

How will you identify oracle database software release?

1005

---

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

1009

---

What is Library Cache in Oracle?

1142

---

What are operators in oracle?

1053

---

What is the usage of analyze command in oracle?

1093

---

How can Oracle users be audited?

1106

---

How to use attributes of the implicit cursor in oracle?

1008

---

What is Reduced List of Values?

2160

---

Difference between cartesian join and cross join?

1033

---

How to list all indexes in your schema?

1087

---

How to import one table back from a dump file?

1025

---

How to define an explicit cursor in oracle?

1034

---