Anonymous blocks: Form the basic PL/SQL block structure Initiate PL/SQL processing tasks from applications Can be nested within the executable section of any PL/SQL block PL/SQL Block Structure DECLARE (optional)… Continue reading "Anonymous Blocks in PL/SQL"
CONTINUE STATEMENT IN PL-SQL Continue Statement: Adds the functionality to begin the next loop iteration Provides programmers with the ability to transfer control to the next iteration of a loop… Continue reading "PL/SQL Continue statement"
For LOOP When to use for loop Use a FOR loop to shortcut the test for the number of iterations. Note: Do not declare the counter, it is declared implicitly Syntax: FOR… Continue reading "PL/SQL for LOOP"
While loop WHILE conditionLOOP statement1; statement2; . . . END LOOP; Use the WHILE loop to repeat statements while a condition is TRUE Note: Use the WHILE loop if the… Continue reading "PL/SQL While LOOP"
Basic LOOP Use the basic loop when the statements inside the loop must execute at least once. Syntax: LOOP statement; . . . EXIT [WHEN condition]; END LOOP; Example: DECLARE… Continue reading "PL/SQL Basic LOOP"