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 are the attributes of cursor?

599

---

How to convert character types to numeric types?

588

---

Can we call procedure inside function in oracle?

619

---

What is meant by an index?

637

---

What are the advantages of oracle?

561

---

---

How to declare a local variable?

608

---

Please explain drop constraint oracle?

636

---

How to connect to the server with user account: sys?

570

---

What are the types of partitions in oracle?

545

---

Which dictionary tables and/or views would you look at to diagnose a locking issue?

1495

---

How to store only time; not date and time?

564

---

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

607

---

How to divide query output into groups in oracle?

567

---

How to do a full database export?

648

---

How to assign a tablespace to a users in oracle?

605

---