Answer Posted / ajit

select *
from emp
where sal = ( select max(sal)
from emp
where level = &n
connect by prior sal > sal
group by level);

What is procedure function?

1054

---

What is scalar data type in pl sql?

1068

---

What is coalesce sql?

997

---

How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?

1134

---

What is difference between rank () row_number () and dense_rank () in sql?

1101

---

Explain polymorphism in pl/sql.

1119

---

How many types of tables are there?

950

---

What is difference between nchar and nvarchar?

1026

---

Is delete faster than truncate?

1002

---

How do we use distinct statement? What is its use?

1030

---

What is the difference between sql and mysql?

1117

---

Is null operator in sql?

1034

---

What are some emotional triggers?

985

---

Why triggers are used?

987

---

Does truncate require commit?

971

---