How do you break a loop in pl sql?

0 Answers  

---

Use The Implicit cursor to Query The Department table information Where Deptno is 30.check,if no record was found then print "Record Was Not Found".Else Print Deptname And Ename.Dept table Have Dname Varchar2(20),Deptno Number,EnameVarchar2(20).Please Answer In 2 mins,with in Maximum 15 lines.

5 Answers   Wipro,

---

Explain dml and ddl?

0 Answers  

---

What is meant by Join? What are the different types of Joins available? Explain.

5 Answers   Cap Gemini,

---

How to update salary of employees department wise?

6 Answers  

---

---

Differentiate between sga and pga.

0 Answers  

---

What is the difference between database trigger and stored procedure?

0 Answers  

---

function can return value ,procedure also return value through out parameter then what is the difference?

3 Answers   3i Infotech,

---

HOW TO APPEAR FOR ONLINE EXAMS OF SQL & PL/SQL? WHICH BOOKS WILL BE BETTER FOR REFERENCE TO QUALIFY THESE EXAMS? ARE THERE ANY MODEL PAPERS AVAILABLE IN THE MARKET ABOUT SQL & PLSQL?

2 Answers  

---

How many parts of a pl sql block are optional?

0 Answers  

---

What is package in pl sql with an examples?

0 Answers  

---

What is the purpose of using pl/sql?

0 Answers  

---