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

Published: 03 May 2023
on channel: Siva Academy
4,869
160

oracle 21c new features | PLSQL Extended Iterators FOR LOOP Enhancements

--------------------------------------------------------------

00:00 Introduction
01:30 For loop in other programming language
04:33 For loop in oracle 19C database
05:47 For loop in oracle 21C database
07:07 21C Example 1 Stepped Range Iteration
08:41 21C Example 2 Fractional Range Iteration
10:04 21C Example 3 Fractional Stepped Range Iteration
11:13 21C Example 4 Single expression Iteration
11:51 21C Example 5 Multiple Iteration ( chaining of Iterations)
--------------------------------------------------------------
This channel is for learning Oracle SQL, PLSQL, DATABASE concepts, MYSQL, ETL, Mongo DB, Python,UNIX and related technologies.
   / sivaacademy  
Home page: https://sivakacademy.blogspot.com/
Telegram Channel : https://t.me/SivaAcademy
--------------------------------------------------------------

Home page: https://sivakacademy.blogspot.com/
List of all oracle SQL/PLSQL Interview questions https://sivakacademy.blogspot.com/p/s...
List of all PLSQL Scenario based Interview Questions https://sivakacademy.blogspot.com/p/p...
List of all Subscriber questions and answers https://sivakacademy.blogspot.com/p/a...

--------------------------------------------------------------

Oracle Interview questions playlist    • oracle interview questions and answer...  
Oracle 18C New features playlist    • Oracle 18C New Feature  
Oracle 12C New features playlist    • Oracle 12C New Feature Series  
Oracle PLSQL records and collections playlist    • oracle plsql records and collections  

--------------------------------------------------------------

My video courses at UDEMY https://www.udemy.com/user/2c29d781-3...

--------------------------------------------------------------
About Myself:
----------------------
I am Siva, [LEARN | CODE | TRAIN | SHARE].
Being in IT industry for more than 12+ years.
In my day to day job, I work with database technologies including Oracle, Java, Python, MongoDB, talend and UNIX.
I am passionate about "DATA", coding & training.
In my spare time, I teach database technologies , ETL etc.
I am very glad that you are reading my Profile, and I value your time as well as mine.
Looking forward to see you in my videos

For any questions, please drop me a mail at [email protected]
--------------------------------------------------------------


Watch video oracle 21c new features for developers PLSQL Extended Iterators FOR LOOP Enhancements online without registration, duration hours minute second in high quality. This video was added by user Siva Academy 03 May 2023, don't forget to share it with your friends and acquaintances, it has been viewed on our site 4,869 once and liked it 160 people.