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
- 3655 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 are packages in db2?
What is the maximum number of columns in a db2 table?
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
What do you mean by rollback?
How does db2 sample database connect?
what is the sqlcode -501
Are view updateable?
What is the role of data manager in the db2 database?
What is the difference between nvl and coalesce?
Is it possible to create an Instance in DB2 using DB2 Control Center ?
What is innodb buffer pool?
How do you stop a db2 database in linux?
What is the reason behind not using select * in embedded sql programs?
What's The Error Code For Unique Index Voilation?
What is an instance database?
