Answer Posted / khan

DELETE FROM
(SELECT EMP_ID, SALARY, DENSE_RANK() OVER (ORDER BY SALARY DESC) AS CNT FROM EMPLOYEE)
WHERE CNT = 3;

Is primary key indexed by default in oracle?

536

---

What are the attributes of cursor?

583

---

What are the different types of record groups in oracle? Explain each of them

596

---

What is varray?

580

---

What is the usage of analyze command in oracle?

609

---

---

How to run create database statement?

567

---

What privilege is needed for a user to connect to oracle server?

551

---

Can select statements be used on views in oracle?

586

---

Define oracle database

590

---

What is define in oracle?

559

---

For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?

1550

---

Can the query output be sorted by multiple columns in oracle?

565

---

What is oracle datasource?

543

---

What is connection pool in oracle?

549

---

What are the limitations of check constraint?

559

---