Interested to Buy Any Domain ? << Click Here >> for more details...
How can you compare table column after update and before
update?
- 5 Answers
- 9869 Views
- Satyam, I also Faced
- E-Mail Answers
Answer Posted / mahesh vasudevan
If you mean a new column has been added to an existing table
or data been updated to an existing table data. I am not
sure on this question. Let me assume that you are talking
about data. Any update that takes place will have two
records logged -one is prior to update and another is after
update and these information goes to Logs. Logs are used
while recovery process for forward and point in time recovery.
and you can make an SQL query for "Union" - "Intersection"
operation to find the differences.
| Is This Answer Correct ? | 0 Yes | 4 No |
Post New Answer View All Answers
What type of database is db2?
What is a bind in db2?
What is isolation level in db2?
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
What is ibm db2 used for?
Is db2 a programming language?
What is db2 instance?
What do you mean by commit and rollback?
What is the information associated with sysibm.syslinks table?
What is buffer pool in the db2 database?
What is the cobol picture clause of the db2 data types date, time, timestamp?
How is the value function used?
What is the difference between cursor and select statement?
What is a trigger in the db2 database?
How to view db2 table structure?
