What is the difference between a package and a plan?

6 Answers   Infosys, L&T, Mphasis,

---

What is the use of runstats in db2?

0 Answers  

---

OUTER JOINS USED TO GET MATCHING AND NONMATCHING ROWS FORM 2 OR MORE TABLES BASED ON COLUMNS. SIMPLE JOINS ALSO DO THE SAME THEN WHAT IS THE USE OF OUTER JOINS.

1 Answers   Syntel,

---

How can you get the number of rows impacted by the last executed query?

1 Answers  

---

What is a LIKE table and how is it created?

2 Answers  

---

how to resolve -811

2 Answers   IBM,

---

what is a plan and how do you refer the plan in the program?

2 Answers   Xansa,

---

What is image copy in db2?

0 Answers  

---

can we drop column from a table

7 Answers   INDUS,

---

assume ther are 5000 records in a database and want to fetch using cursor. cursor fetches only 3000 records and fetch is not happening for remaining 2000 records. why it happens and how to rectify it

1 Answers   TCS,

---

How can you quickly find out the # of rows updated after an update statement?

0 Answers  

---

Explain the function done by data manager?

0 Answers  

---