CURRENT OF clause in PL/SQL | Oracle PL/SQL Tutorial Videos | Mr.Vijay Kumar

[@NareshIT]

Please Comment, Subscribe and Click Bell🔔🔔🔔 Icon for More Updates. To learn software course from our experts please register here for online training: goo.gl/HIB0wL

[@aakashdubey9653]

One of the best videos, kudos to you Sir

[@sastabhalogger3525]

He is the best Oracle teacher. I learnt pl/sql from some other institute they took 12k and they completed everything in 40 days. Then After 2 month I joined NarshIt only for 2k and sir is covering every small details of pl/sql. I am thinking I should have joined earlier here.

[@foodfairyshi]

Amazing explanation. Thank you so much for making this video. I was confused about this concept for a long time, I have read about this in many tutorial pages but only after watching your video. I understood well and I am confident with that concept.

[@pavanmadamset]

Excellent Explanation Sir! Thank You Very Much, Vijay Kumar Sir!!! I am learning because of You Sir!!!

[@jajatikesharisahoo8628]

Awesome explanation..............

[@siddharthapenchala8146]

Nice Explanation...Thanks..

[@dreamvallyhasan4807]

Excellent

[@shashank2004]

Awsome ..Nice explanation sir,pls make a video on collection, bulk collect,bulk binding ,record type and hints and performance tuning

[@Crazy4DB]

Sir, I wonder in the example you have given here why you are required to use the loop. If everybody's salary is required to be raised by thousand then even without using loop we could have used simple : update emp44 set salary = salary + 1000; plz clarify the need to use the cursor for loop?

[@PrasanthMunaga]

thank you very much sir.

[@sandeeppatnaik4519]

I both cases employee A and B added 1000 2 times? No?

[@prajithgoud914]

thanks for the video

[@sivakrishnapurushotham1849]

sir, I have a doubt (consider there is a procedure it may run 20 thousand SQL queries at a time after 15 thousand queries execution procedure fail how to overcome this issue which exception handling method is used to solve this problem

[@shaheenshaikh6701]

Sir what is fir update of sal nowait , what does nowait stands for plz expln thnks!

[@chirumamillasuresh3279]

where current of clause is useful when a table doesn't have unique values column or the table contains duplicate records or updating of column based on some condition then only where current of clause is useful. otherwise if a table contains unique values or table doesn't contain duplicate records or updating column value without any condition then no need of the where current of clause.

[@chirumamillasuresh3279]

This is the simple program to update all employee salary by 1000. begin update emp44 set sal=sal+1000; end; /

[@thapadheeraj2006]

This can be done using rowid pseudocolumn.

[@siddanthsiddu5885]

explain about nowait sir

[@shaheenshaikh6701]

What is nowait sir