Hello Experts,
I have this query
How does update statement works in architecture level?
please share your valuable thoughts.
Sugandh || 17 Jun 2018 3:12 pm || 3
How does Update Statement Works in Architecture Level?
Hello Experts,
I have this query
How does update statement works in architecture level?
please share your valuable thoughts.
Comments
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.
Sqlplus scott/tiger@prod
SQL>select * from emp;
SQL>update emp set sallary=30000 where empid=10;
SQL>commit;
So we will understand what is happening internaly
Related Articles
Tutorials
Sqlplus scott/tiger@prod
SQL>select * from emp;
SQL>update emp set sallary=30000 where empid=10;
SQL>commit;
So we will understand what is happening internaly