oracle 21c new features for developers PLSQL Extended Iterators FOR LOOP Enhancements

[@vivektarab16]

Start - 0:26 - New Features added in Oracle 21c 1:25 - Examples of Old For Loop 2:37 - Example in Python 3:00 - In Oracle For Loop 4:16 - Telling what 21C has 4:33 - Oracle 19 C 5:38 - Again What in 21 C 7:00 - Stepped Range Iteration 8:40 - Fractional Range Iteration 10:04 - Fractional Stepped Range iteration 11:13 - Single Expression Iteration 11:52 - Multiple Iteration (Chaining of Iterations)

[@tej1316]

Thank you Sir, awaiting for all videos in this series.

[@SivaAcademy]

Welcome, sure, please stay tuned

[@kanchanadeviraju7365]

Thanks for very clear Explanation on new concepts!!

[@SivaAcademy]

Welcome

[@azmath4710]

Great!!, New concepts to learn

[@SivaAcademy]

Thank you

[@gundeboyinanagaraju9041]

Love you anna. Great information.... thankyou anna.keep going.❤❤❤❤

[@SivaAcademy]

Thank you bro 💐

[@naveenkumar-um6vm]

Hi Siva, Nice explanation for each feature. It will be good for the developers to enhance their programs. Please continue remaining series for the same. One request from my side please make a complete video on Oracle Architechture.

[@SivaAcademy]

Thank you very much, sure please stay tuned

[@ShaikAbdulFayazYCE]

Sir i have a doubt could you please explain this question is Assume a table named Students (Name, Scores) contains the names of different students and their respective scores. Assuming that no two students have the same scores, what is the output of following query? Select Name from Students as B where( SELECT count(*) from students as T where T. Scores>B.Scores)

[@nandinimnair9915]

Hi sir can you please let me know which one is better,cursor fetch or a simple for loop?

[@SivaAcademy]

There is nothing like better, it all depends on the requirement

[@kirthiraju4845]

Cursor

[@saratchand4275]

could u please explain how to fix the minutes in update statement in oracle 11g environment

[@akshardrashti]

Thank you for making this video

[@SivaAcademy]

Welcome

[@ShabbirAhmad-sv2kq]

Thank you 😊

[@SivaAcademy]

Welcome bro

[@learnCodingTechguru]

Hi Sir, Your videos are very helpful for interviews. Thank you 😊. Please make a video on gather statistics and join methods(nested loop join, sort merge join and hash join). Thanks in advance

[@SivaAcademy]

Thank you very much, sure, please stay tuned

[@learnCodingTechguru]

Thank you Sir 🙏

[@akshardrashti]

Yes, I am facing this question in every interview

[@subratkumar123bobby]

Great sir

[@SivaAcademy]

Thank you 💐

[@sivaprasadreddys2742]

Super anna❤

[@SivaAcademy]

Thank you bro

[@avulavenkatesh6921]

Thank you Sir, Can you please make a vidoe on pipelined function. Thanks in advance ❤

[@SivaAcademy]

Its already posted bro, please look into this video kzbin.info/www/bejne/b3W4eYBsprughqM

[@avulavenkatesh6921]

Thanks much Sir ❤️

[@geeta59]

Can we iterate over multiple selects in same for loop?

[@SivaAcademy]

Yes, you can chain multiple select Statement

[@TheKetan4500]

thanks for new video

[@SivaAcademy]

Welcome bro

[@Asryoutube]

PL/SQL is fun, Steven Feuerstein is God and Siva is the messenger. I feel pity for those who still believe PL/SQL isn't a proper programming language.

[@SivaAcademy]

😂 Thank you