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

CURRENT OF clause in PL/SQL

[aakashdubey]

One of the best videos, kudos to you Sir

[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.

[sastabhalogger]

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.

[pavanmadamset]

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

[shashank]

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

[CrazyDB]

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?

[sandeeppatnaik]

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

[shaheenshaikh]

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

[sivakrishnapurushotham]

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

[chirumamillasuresh]

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.

[thapadheeraj]

This can be done using rowid pseudocolumn.

[chirumamillasuresh]

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