I have this query
How does update statement works in architecture level?
please share your valuable thoughts.
SQL>select * from emp;
SQL>update emp set sallary=30000 where empid=10;
So we will understand what is happening internaly
First you read DB Architecture..In Architecture read carefully Redo & Undo role...Rest thing you can understand..If you fire Update statement
1.background process check permission of user,statement syntax.
2. update database as u fire command.
3. save old value or New Value with time stamp.
4. after commit command save your updated data in your Physical storage..I hope u under stand.