Oracle PL SQL interview question Explain FOR UPDATE clause and WHERE CURRENT OF Clause 

Thank you 💐

My pleasure, thank you

Welcome bro, thanks for your comments

My pleasure 💐💐🙏 thank you

Welcome bro

Welcome 🙏 thank you

Thanks and welcome bro

My pleasure, thank you 💐

Thank you

My pleasure, thank you 💐

Welcome 🙏

Its my pleasure thank you 🙏

Thank you

:-) I am not running any training center bro... thanks bro for your comments

Welcome bro

Thank you bro

Welcome 🙏

@Rahul, Thank your....🙏

Thank you

@Sridhar..... Thank you bro....🙏

Thank you

Thanks bro 🙏

Welcome 🙏

It's my pleasure,Thank you so much :-)

Thank you

Welcome

@Abinash, Sure bro, once the cursor videos are completed, i will start with mutating trigger and join related videos.... Please stay tuned....

@Viji, 🙏🙏🙏.... Thank you so much for your wishes bro..... :-)

@Archana, Thanks, I have covered the version specific new features in separate video series for 12C, 18C and 19C. however will try to post a short video from interview aspect soon.

Thank you

Thank you

Thanks

🙏💐

@Bharathi, triggers will get executed in the same order, like 1. Before statement, 2.Before Row, 3, After Row, and Finally 4. After Statement,.... However if you have two same type of triggers, then you can specify what should follow others using the "FOLLOWS" or "PRECEDES" key word...... you can look into this documentation page for the syntax. docs.oracle.com/en/database/oracle/oracle-database/19/lnpls/CREATE-TRIGGER-statement.html#GUID-AF9E33F1-64D1-4382-A6A4-EC33C36F237B I will post an example later....Please stay tuned.

Thank you... I dont think so, i will post a seperate video on deadlock handling, please stay tuned

@Pritam, Please watch this video, ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-nHL1YgtTapA.html You can answer based on this....

sure

@datta, sure, I will post a separate video on inbuilt packages.

@Savithiri, Sure, will post a video of data migration, however there are lot of pending request stilll, hence i may take some more time to post this, however i will definitely post this info....Please stay tuned.

@Siva, It's my pleasure :-)

@Rahul, Sure, i will post a separate video on interview question series....Please stay tuned.

make it fast, sir, please......

@Rahul, Sure....there are 2 more pending questions on cursor....once cursor related questions are done, the next video is on mutating trigger only...

ok sir, thank you so much have a good day sir.

give permission i.e grant execute on sys.dbms_lock to user_name by looging into sysdba role