hi, you are wrong in saying oracle db cannot select data for U2 user when U1 user is updating a record. Select will be possible for U2 but update will have to wait as U1 is holding a lock on the record.
Your information is wrong and not authentic about oracle lock.There is isolation levels available to access the data and undo data is used if a row is locked.
hi, you are wrong in saying oracle db cannot select data for U2 user when U1 user is updating a record. Select will be possible for U2 but update will have to wait as U1 is holding a lock on the record.
Yes I agree with my mistake.
Select is possible but update is not possible when we try to update same row
Yes why you are saying U2 not able to select in Oracle
Sole purpose of undo is demolished Ankush.
Intrested!
I think you should update the video with annotation about mistakes.
Hi.. How to undo the things I learnt from your video
Hi Anukush Interested .. please share all topics practical videos
please connect with this number 7822917585
Hi sir..I am working as a database developer with 9 yrs experience so to boost the profile or increase the PKG should I learn postgresql dba?
yes
Intrested
Interested
Interested
For more details you can contact us on +91 7757062955
Interested
Read about undo management first , v2 user can read but can't run dml
Interested ❤
Your information is wrong and not authentic about oracle lock.There is isolation levels available to access the data and undo data is used if a row is locked.
interested
Great to hear you're interested! You can contact us at +91 7757062955 for more details.
Intersted
please connect with this number 7822917585 and join this group chat.whatsapp.com/H6hNEtmTt2jGDdlR6mcRoB
interested
Intrested
Interested
Interested
Interested
Interested
Interested
Interested
Interested
Interested
Interested
Interested
Interested
Interested
Interested
Interested
chat.whatsapp.com/H6hNEtmTt2jGDdlR6mcRoB
Interested
chat.whatsapp.com/H6hNEtmTt2jGDdlR6mcRoB
Interested
please connect with this number 7822917585