Answer Posted / nagaraj a h

SELECT DISTINCT (a.sal) FROM EMP A WHERE &N = (SELECT COUNT
(DISTINCT (b.sal)) FROM EMP B WHERE a.sal<=b.sal);

What is tns service name?

619

---

How to drop a stored procedure in oracle?

590

---

How do I find my oracle client driver version?

526

---

Is oracle a relational database?

520

---

Why does oracle 9i treat an empty string as null?

538

---

---

How to write a query with a left outer join in oracle?

605

---

How to delete an existing row from a table in oracle?

641

---

What privilege is needed for a user to create indexes in oracle?

574

---

Write a syntax for update query in oracle?

618

---

6. Display the client name and order date for all orders using the traditional method.

1747

---

Explain coalesce function?

624

---

what is insert all statement in sql

5509

---

What is a initialization parameter file in oracle?

584

---

Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.

859

---

What is partitioned table in Oracle?

634

---