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

preview_player
Показать описание
CURRENT OF clause in PL/SQL
Рекомендации по теме
Комментарии
Автор

One of the best videos, kudos to you Sir

aakashdubey
Автор

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.

foodfairyshi
Автор

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.

sastabhalogger
Автор

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

pavanmadamset
Автор

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

shashank
Автор

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?

CrazyDB
Автор

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

sandeeppatnaik
Автор

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

shaheenshaikh
Автор

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

sivakrishnapurushotham
Автор

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.

chirumamillasuresh
Автор

This can be done using rowid pseudocolumn.

thapadheeraj
Автор

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

chirumamillasuresh
visit shbcf.ru