PLAN IS EXECUTABLE AND PACKAGE IS NOT EXECUTABLE . THEN WHAT IS THE USE OF PACKAGE?

2 Answers   Tech Mahindra, Wipro,

---

In cursor program-1 can we create another cursor program-2 inside the cursor program-1.If yes how/no why ?

2 Answers   Wipro,

---

if suppose i am having an ACCOUNT table with 3 coloumns ACC. NO,ACC. NAME,ACC. AMOUNT . If a unique index is also defined on ACC.NO and ACC.NAME then write a query to retrieve account holders records who have more than 1 ACC.

8 Answers   Wipro,

---

What is db2 bind process?

0 Answers  

---

Could you please let me no the query for below I have table name xyx under this there is column name called employee name which starts from 100th column ends 120th column,now i want to replace only column from 101 to 104 which contains ABCS to replace with PQRS for all records which comes beetween 101 to 104 ..how to write query for this..

1 Answers   HSBC,

---

---

What is the use of COMMAREA ?Minimum how much data we can pass from it?

7 Answers   Cap Gemini,

---

What is query for your birthday date should be in hours,minute and seconds format?

1 Answers   Fidelity,

---

How do you simulate the explain of an embedded sql statement in spufi/qmf?

0 Answers  

---

Why use RUNSTAT Utility?

3 Answers   Merrill Lynch,

---

What are the various locks available?

5 Answers   CTS,

---

where can we use index and subscript ? with example ?

3 Answers   CTS,

---

What is the SQL Communications Area and what are some of its key fields?

1 Answers  

---