can we drop column from a table

7 Answers   INDUS,

---

what is static sql? what is dynamic sql? Give me details

3 Answers  

---

What is the difference between oracle and db2?

0 Answers  

---

What's the Maximum Length of SQLCA and what's the content of SQLCABC?

2 Answers  

---

What is the syntax required for the creation of a cursor?

1 Answers  

---

What is correlated subquery?

1 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 sqlca’s maximum length?

0 Answers  

---

Explain various types of locks in db2?

0 Answers  

---

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

2 Answers   Xansa,

---

Hi i need to write a query on the following requirement. SELECT COMM_TEXT INTO :WS_MIKM_COMM_TEXT FROM MPIPROD.MIKMV01 WHERE ACCOUNT_NO = :WFD_ACCOUNT_NO AND (SUBSTR(COMM_TEXT,1,39) = :WS_COMMENT_TEXT AND SUBSTR(COMM_TEXT,47,14) = :WS_DENY_DESC) OR (SUBSTR(COMM_TEXT,1,39) = :WS_COMMENT_TEXT) The above query is to be modified. The requirement is if both the fields are equal then that has to be given priority. In the above query if it satisfies any one it comes out without checking if both being equal is possible.

1 Answers  

---

What is meant by explain?

0 Answers  

---