May 18, 2024
Control statements in Advanced Database Concepts | Prof. Sonam Jangam | PHCASC

Control statements in Advanced Database Concepts | Prof. Sonam Jangam | PHCASC

Control statements in Advanced Database Concepts | Prof. Sonam Jangam | PHCASC

Video by MES e-Learning via YouTube
Source
Control statements in Advanced Database Concepts | Prof. Sonam Jangam | PHCASC

"PL/SQL has three categories of control statements: conditional selection statements, loop statements and sequential control statements.

PL/SQL categories of control statements are:

Conditional selection statements: which run different statements for different data values.

The conditional selection statements are IF and CASE.

Loop statements: which run the same statements with a series of different data values.

The loop statements are the basic LOOP, FOR LOOP, and WHILE LOOP.

Sequential control statements: which are not crucial to PL/SQL programming.

The sequential control statements are GOTO, which goes to a specified statement, and NULL, which does nothing."

Go to Source