Subscriber Comments Reply Video 62 | Will trigger gets executed even if no rows are updated

[@md.selimhossain4181]

Really, Your Explanation Is Awesome. Great...

[@palanivelu.a]

sir,how to know which trigger get executed, if we don't display the output?

[@vikassuri6474]

your way to explain with examples is awesome, keep it up

[@SivaAcademy]

Thank you

[@rishikeshkarn7312]

I have questions .... Like suppose I want to fetch data from table which is under lock condition then what we have to do ?? Interview questions

[@SivaAcademy]

You can still fetch the data, however you will be able to read only the committed data, I will cover in next video with few more scenarios covering this case, please stay tuned

[@santoshpanigrahi205]

Siva please cover all locking types in Oracle with examples in your style of explanation. I have searched many places but still the concept is not clear.

[@rishikeshkarn7312]

@@SivaAcademy kindly share email id sir.. giving interview now day...just because layoffs i lost my job..need ur help..

[@SivaAcademy]

Sure bro, I will cover in upcoming videos, if still have any questions, you can always send me back, so that I can cover as much as possible

[@SivaAcademy]

Please send mail to [e-mail]

[@abhijitmane9949]

Very tricky question but @ the same time nice explanation. Great Thanks

[@SivaAcademy]

Thank you

[@mrarjitvlog5180]

Your the best mentor for sql in youtube

[@SivaAcademy]

My pleasure 🙏💐

[@yogeshzore5766]

Great info Sir..🙏

[@SivaAcademy]

Welcome bro

[@sonusharma25801]

Thanks for posting ❤❤

[@SivaAcademy]

Thank you 💐

[@mhalappatengale8980]

Is better do career in plsql or which languages should learn with plsql

[@shashank2004]

Nice explanation bro.. Pls make a video on index scan methods and nested loop join, sort merge join and hash join.

[@SivaAcademy]

Sure bro

[@sanjithj]

Thanks for the informative session. I think Order of trigger execution is already covered in one video. I have a quick question. Will Row level trigger gets fired for a query like below : Update employee set sal=sal where empid=1; Here the condition satisfies. But no value is getting changed with the update statement.

[@SivaAcademy]

Yes Sanjith, row level trigger will get executed for this case also

[@TheKetan4500]

Thanks for updating video

[@SivaAcademy]

Welcome bro

[@gomathis9725]

Hello Siva, I'm looking for job opportunities in onshore. I worked as Oracle PlSql developer for many yrs in IND. Could you please share which technology in additional for upgrading Oracle profile/ mean more market opportunity tech?

[@santoshpanigrahi205]

Informative

[@SivaAcademy]

Thank you

[@nagaa225]

Hi Siva, Pls do video on oracle queues

[@SivaAcademy]

Sure bro, please stay tuned

[@nagaa225]

@@SivaAcademy Thank you Bro

[@devendrakumar-w5y]

Please upload vedio for SQL vs dynamic SQL And about partition and bulk load

[@SivaAcademy]

Sure, please stay, For bulk load you can look into this video kzbin.info/www/bejne/mYKVh2hmnLRno6c

[@rishikeshkarn7312]

First view

[@SivaAcademy]

:-)