Answer Posted / sam

Guys
See the correct answer.

select distinct sal from emp a where 4 =(select
count(distinct(sal)) from emp where a.sal <= sal)

What is a subquery in oracle?

1043

---

Is rowid unique in oracle?

939

---

What do you understand by database schema and what does it hold?

1180

---

21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.

2046

---

How to use null as conditions in oracle?

1003

---

Point the difference between translate and replace?

1028

---

Does oracle partitioning improve performance?

947

---

What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar

4482

---

Can you assign multiple query result rows to a variable?

933

---

What is save point in oracle database?

1243

---

What is the difference between sharding and partitioning?

931

---

I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?

2398

---

What is concurrency in oracle?

949

---

What are transaction isolation levels supported by oracle?

997

---

What are internal user account in oracle?

950

---