Answer / Vipnesh Sharma

"dense_rank() in SQL/PLSQL is a window function that assigns consecutive integers to each row within a partition, without any gaps."

What is the difference between view and stored procedure?

1 Answers  

---

What is rowid in sql?

1 Answers  

---

Can we relate two different tables from two different users in ORACLE,PL/SQL?

4 Answers  

---

How do I remove sql developer from windows 10?

1 Answers  

---

Does sql*plus also have a pl/sql engine?

1 Answers  

---

Show the cursor attributes of pl/sql.

1 Answers  

---

what is bulk bind

4 Answers   TCS,

---

Q1.all the depts which has more then 10 empls? Q2.all the dept which does not have any emply? Q3 all the emp which does not have any dept? Q4 get all the emply detais with the dept details it dept is exit otherwise any emp details? Q5 how to debugg the dynamic sql and packages?

4 Answers   KPIT,

---

Describe sql comments?

1 Answers  

---

What is an implicit commit?

1 Answers  

---

what is the purpose of update command in oracle?

7 Answers   MBT,

---

What are different types of indexes?

1 Answers  

---