Answer Posted / srikanth

select * from (select e.*,rank() over(order by salary desc
nulls last) sal_rnk from employee e)where sal_rnk=3;

How can a pl sql block be executed?

533

---

What is delimiter sql?

548

---

What is sql deadlock?

567

---

Explain how exception handling is done in advance pl/sql?

561

---

Is left join faster than join?

549

---

---

Why do we use sql constraints? Which constraints we can use while creating database in sql?

551

---

what is transaction? : Sql dba

532

---

What is data control language (dcl)?

603

---

Can we write ddl statements in functions?

569

---

Can we insert data into materialized view?

519

---

what is bcp? When is it used?

584

---

What is the process of debugging?

557

---

Why sql query is slow?

583

---

Does a join table need a primary key?

534

---

What is triggering circuit?

597

---