What are the advantages of stored procedure?

0 Answers  

---

What is a primary key called that is made up of more than one field?

0 Answers  

---

What is difference between inner join and self join?

0 Answers  

---

Why are indexes and views important to an organization?

0 Answers  

---

What are the steps you take to tune(performance tuning) the code in plsql?

4 Answers   Cap Gemini, Infosys, TCS,

---

I have a small PL/SQL Block assume in this way begin select * from emp where empno=100; exception when others then <Some Messages> when no_data_found then <Some Messages> when too_many_rows then <Some Messages> end; The question which he asked was whether this block will get executed normally or it will throw error ? If errored out then what is the reason for the error ? Could anybody please help me ? Regards Nakul Venkataraman

3 Answers   Satyam,

---

Which is better cte or subquery?

0 Answers  

---

What is the use of non clustered index?

0 Answers  

---

Can you join a table to itself?

0 Answers  

---

How do I find sql profiler?

0 Answers  

---

what are wild cards used in database for pattern matching ? : Sql dba

0 Answers  

---

Why stored procedures are faster than query?

0 Answers  

---