PLSQL LOOPS with Examples | Basic Loop, While Loop, For Loop in Pl/SQL | PL-SQL Course Tutorial 202

In this video, I have discussed basic loop, while loop, and for loop in pl/sql
"PL SQL LOOPS with Examples | Basic Loop, While Loop, For Loop in Pl/SQL | PL-SQL Full Course Tutorial 2023

#plsql #plsqlloop #plsqlforloop #plsqlwhileloop,plsqlenglish #loop #basicloop #whileloop #forloop #plsqltutorial #plsqltutorialinenglish #PLSQL #plsqlforbeginners #plsqlbasics #plsqlprocedures #plsqlcursor #plsqlfunctions #plsqltriggers #plsqlvssql #oracleplsql #PLSQLtutorialforbeginners #PLSQLtutorialinenglish #plsqlinterview #plsqlinenglish #parnikatutorials #plsql2023 #plsqlfullcourse2023 #plsqlfullcrashcourse2023 #plsqlcrashcourse #plsqlcourse2023

00:58 - basic loop intro
02:25 - basic loop syntax
08:03 - while loop syntax
13:21 - for loop syntax"

The PL/SQL loops are used to repeat the execution of one or more statements for specified number of times. These are also known as iterative control statements.

There are 3 types of PL/SQL Loops.

Basic Loop / Exit Loop
While Loop
For Loop

Basic Loop

PL/SQL basic loop is used when a set of statements is to be executed at least once before the termination of the loop. There must be an EXIT condition specified in the loop, otherwise the loop will get into an infinite number of iterations. After the occurrence of EXIT condition, the process exits the loop.

LOOP
Sequence of statements;
END LOOP;

Note: You must follow these steps while using PL/SQL basic Loop.

Initialize a variable before the loop body
Increment the variable in the loop.
You should use EXIT WHEN statement to exit from the Loop. Otherwise the EXIT statement without WHEN condition, the statements in the Loop is executed only once.

While Loop

PL/SQL while loop is used when a set of statements has to be executed as long as a condition is true, the While loop is used. The condition is decided at the beginning of each iteration and continues until the condition becomes false.

WHILE (condition)
LOOP statements;
END LOOP;

Note: You must follow these steps while using PL/SQL WHILE Loop.

Initialize a variable before the loop body.
Increment the variable in the loop.
You can use EXIT WHEN statements and EXIT statements in While loop but it is not done often.

FOR Loop
PL/SQL for loop is used when when you want to execute a set of statements for a predetermined number of times. The loop is iterated between the start and end integer values. The counter is always incremented by 1 and once the counter reaches the value of end integer, the loop ends.

Syntax of for loop:

FOR counter IN initial_value .. final_value LOOP
LOOP statements;
END LOOP;

initial_value : Start integer value
final_value : End integer value

You don't need to declare the counter variable explicitly because it is declared implicitly in the declaration section.
The counter variable is incremented by 1 and does not need to be incremented explicitly.
You can use EXIT WHEN statements and EXIT statements in FOR Loops but it is not done often.

Social media Links:
Instagram: https://www.instagram.com/parnikatutorials/
Website: http://parnikatutorials.in/
Email id: [email protected]
To get the regular updates:
Telegram link: https://t.me/Parnikatutorials
Facebook: https://m.facebook.com/profile.php?id=109245950811428&ref=content_filter
Linkedin: https://www.linkedin.com/in/parnika-tutorials-a8a9831b2/
Pinterest: https://in.pinterest.com/parnikatutorials0892/
Playlists:
Virtual Coffee with Jagadeesh:
https://youtube.com/playlist?list=PL4x0v29DZ2pArePUk30o6Twn7sqnqbYCH
Digital Logic Design:
https://youtube.com/playlist?list=PL4x0v29DZ2pA2ZmL3dclnA-HfHkFAy0GI
Computer Organization and Architecture:
https://www.youtube.com/watch?v=iJN9q01OWtw&list=PL4x0v29DZ2pBRd8bChJJFtTn6ClJhKzfZ
C Programming:
https://www.youtube.com/watch?v=h9LtX_R-7uA&list=PL4x0v29DZ2pAIQdtRr-1zaYnqGiD_fU0M
Data Structures:
https://www.youtube.com/watch?v=m51BGPXdPAQ&list=PL4x0v29DZ2pCtKml6NNoBhYK4K_QnsCA_

Theory of Computation:
https://www.youtube.com/watch?v=iJN9q01OWtw&list=PL4x0v29DZ2pDq-5SI9KlYxPDKdYCcmgJm

Compiler Design:
https://www.youtube.com/watch?v=iJN9q01OWtw&list=PL4x0v29DZ2pBsF-lPUHQ_8uRy-LbDSHIH
Operating Systems: https://www.youtube.com/watch?v=vCCmq8hTC8Y&list=PL4x0v29DZ2pD6MzSQMIDSawLSKUZTFfxE

Databases: https://www.youtube.com/watch?v=iJN9q01OWtw&list=PL4x0v29DZ2pCYEa9s3r5zWrFYIxGivlEC

Computer Networks:
https://www.youtube.com/watch?v=iJN9q01OWtw&list=PL4x0v29DZ2pBBOq-QsHtCuA53IlRxIQNm
For GATE PYQs and much more explore:
https://www.youtube.com/c/ParnikaTutorials/playlists