Oracle - PL/SQL - Advanced Cursors

preview_player
Показать описание
Oracle - PL/SQL - Advanced Cursors
Lecture By: Mr. Anadi Sharma, Tutorials Point India Private Limited.
Рекомендации по теме
Комментарии
Автор

Use coupon "YOUTUBE12" to get ‘’FLAT 12%’’ OFF at Checkout.

TutorialsPoint_
Автор

Hello, So glad to see your lecture, doubt I have is no where in the FOR UPDATE CURSOR statements you really OPENED/CLOSED the cursor. Is it not necessary?

cwpvnew
Автор

In the example, where you are showing FOR UPDATE OF CLAUSE, you are not opening or closing the CURSOR.. Isnt it required? if you dont open or close the cursor, and directly perform UPDATE at the table level, what does that mean? what is the difference if you do or dont use open and close cursor here....

chitritakundu
Автор

Sir you updated the data without opening cursor in the where current of example, will it work ?

benimbenzeer
Автор

good lecture. sir, please make videos of these topics in Hindi

shahzadprince
Автор

what is that emp_record.salary ..?
am a beginner so having trouble understanding the terms clearly.
hope, i will get a answer

vineshgummula
Автор

if i case dept_id is other than 50 what should do

sreekanth
Автор

In the example you are trying to update salary in loop using cursor, you haven't opened or closed the cursor..

So can we say opening and closing cursor are not mandatory??

ItsMePhaniY
Автор

For practicing plsql which database we have to install

kishorejohn