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
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.
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.
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?
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.
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
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
One of the best videos, kudos to you Sir
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.
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.
Excellent Explanation Sir! Thank You Very Much, Vijay Kumar Sir!!! I am learning because of You Sir!!!
Awesome explanation..............
Awsome ..Nice explanation sir,pls make a video on collection, bulk collect,bulk binding ,record type and hints and performance tuning
Excellent
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?
Nice Explanation...Thanks..
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.
thank you very much sir.
This is the simple program to update all employee salary by 1000.
begin
update emp44 set sal=sal+1000;
end;
/
thanks for the video
I both cases employee A and B added 1000 2 times? No?
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
Sir what is fir update of sal nowait , what does nowait stands for plz expln thnks!
explain about nowait sir
This can be done using rowid pseudocolumn.
What is nowait sir