Answer Posted / swastik

SELECT LEVEL, MAX(Sal)
FROM Emp
GROUP BY LEVEL
HAVING LEVEL = &GiveNo
CONNECT BY PRIOR Sal > Sal;

What is mutating table error?

882

---

Explain about various levels of constraint.

702

---

What are the types of subqueries?

768

---

Are left and right joins the same?

720

---

What is data definition language?

803

---

---

What is sqlite format?

816

---

Why is sql*loader direct path so fast?

799

---

What are sql constraints?

788

---

What is pl sql in oracle?

785

---

How are functions and procedures called in PL/SQL?

802

---

What is input buffer in sql*plus?

825

---

What is the difference between syntax error and runtime error?

811

---

Can we use view in stored procedure?

700

---

Enlist the characteristics of pl/sql?

1491

---

What is not equal in sql?

697

---