Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 3598 Views
- HSBC, I also Faced
- E-Mail Answers
Answer Posted / devika
update XYZ
set empname(2,4) = 'PQRS'
where substr(empname(2,4))='ABCS'
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is the meaning concurrency in the db2 database?
What is null indicator in cobol db2?
How to get the ddl of a table in db2?
What is iseries database?
How to restart a DB2 program?
what is the responsibility of the construction superintendent
Mention the downsides of page level lock.
Explain how can you do the explain of a dynamic sql statement?
Define db2.
What is dbrm? What it contains?
Differentiate between cs and rr isolation levels? Where do you specify them?
Define db2 and its databases?
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
what is utility for parm lib
What is cloudant database?
