Answer Posted / mohd. rashid

SELECT TOP 1 salary
FROM(
SELECT DISTINCT TOP 3 salary
FROM employee
ORDER BY salary DESC)
ORDER BY salary

What is PL/SQL ?

1111

---

Oracle

1849

---

What is the difference between sharding and replication?

475

---

What is a proxy class?

557

---

What are the major difference between truncate and delete?

517

---

---

Can we use oracle pl/sql block in core java? if so how? pls get back to me .....

2502

---

How to get maxsal , minsal, ename department wise in single query

1014

---

Explain the different normalization forms?

591

---

I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.

1854

---

How will you identify oracle database software release?

525

---

Where are the settings stored for each instance in oracle?

621

---

Why cursor variables are easier to use than cursors?

570

---

What is a table index in oracle?

632

---

What are the logical operations?

677

---

What is system global area (sga) in oracle?

571

---