Answer Posted / mahendra

SELECT max(salary) FROM Employee WHERE salary NOT IN
(SELECT max(salary) FROM Employee);

Name the various constraints used in oracle?

562

---

What is oracle server autotrace in oracle?

614

---

What are the attributes of the cursor?

555

---

Explain implicit cursor.

553

---

Why is oracle so popular?

558

---

---

Why is oracle database so popular?

564

---

How to call a stored function in oracle?

572

---

How to get a create statement for an existing table?

572

---

What is instant client oracle?

539

---

How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?

544

---

Why do we need integrity constraints in a database?

585

---

What is the difference between translate and replace?

556

---

Explain about the analyze command in oracle?

585

---

What is meant by a deadlock situation?

576

---

What is merge in oracle?

558

---