Answer / Jogendra Kumar

In SQL/PLSQL, the BREAK keyword is used to exit from a loop prematurely. It can be used within the LOOP or WHILE construct.

Which is faster union or join?

1 Answers  

---

What is compiled query?

1 Answers  

---

Does it possible to pass object (or) table as an argument to a remote procedure?

1 Answers   TCS,

---

How many types of sql are there?

1 Answers  

---

Which kind of parameters cannot have a default value in pl sql?

1 Answers  

---

What is the use of index in sql?

1 Answers  

---

Can we debug stored procedure?

1 Answers  

---

What does the hierarchical profiler does?

1 Answers  

---

What are analytical functions in sql?

1 Answers  

---

What will you get by the cursor attribute sql%rowcount?

1 Answers  

---

What are the query optimization techniques?

1 Answers  

---

How does pl sql work?

1 Answers  

---