Oracle PL SQL Conditional Statements | Conditional Statements in Pl/SQL | PL/SQL tutorial 2023 | PT

Опубликовано: 12 Сентябрь 2022
на канале: Parnika Tutorials

431

" Oracle PL SQL Conditional Statements | Conditional Statements in Pl/SQL | PL/SQL tutorial"

#plsql #oraclesql #parnikatutorials #dbms #conditionalstatements
#plsqltutorial #plsqltutorialinenglish #PLSQL #plsqlforbeginners #plsqlbasics #plsqlprocedures #plsqlcursor #plsqlfunctions #plsqltriggers #plsqlvssql #oracleplsql #PLSQLtutorialforbeginners #PLSQLtutorialinenglish #plsqlinterview #plsqlinenglish

00:12 - conditional statements
01:40 - comparsion operators
1:52 - logical operators
02:20 - types of conditional statements in plsql
11:40 - plsqlprogram
15:07 - salary assigments operators "

In this video, I have discussed conditional statements in pl/sql
#pl/sql #oraclesql #parnikatutorials #dbms #conditionalstatements

PL/SQL supports the programming language features like conditional statements and iterative statements. Its programming constructs are similar to how you use in programming languages like Java and C++.

Syntax for IF Statement:

There are different syntaxes for the IF-THEN-ELSE statement.

Syntax: (IF-THEN statement):

IF condition
THEN
Statement: {It is executed when condition is true}
END IF;

This syntax is used when you want to execute statements only when condition is TRUE.

Syntax: (IF-THEN-ELSE statement):

IF condition
THEN
{...statements to execute when condition is TRUE...}
ELSE
{...statements to execute when condition is FALSE...}
END IF;
This syntax is used when you want to execute one set of statements when condition is TRUE or a different set of statements when condition is FALSE.

Syntax: (IF-THEN-ELSIF statement):

IF condition1
THEN
{...statements to execute when condition1 is TRUE...}
ELSIF condition2
THEN
{...statements to execute when condition2 is TRUE...}
END IF;
This syntax is used when you want to execute one set of statements when condition1 is TRUE or a different set of statements when condition2 is TRUE.

Syntax: (IF-THEN-ELSIF-ELSE statement):

IF condition1
THEN
{...statements to execute when condition1 is TRUE...}
ELSIF condition2
THEN
{...statements to execute when condition2 is TRUE...}
ELSE
{...statements to execute when both condition1 and condition2 are FALSE...}
END IF;
It is the most advance syntax and used if you want to execute one set of statements when condition1 is TRUE, a different set of statement when condition2 is TRUE or a different set of statements when both the condition1 and condition2 are FALSE.

Social media Links:
Instagram:   / 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...
Linkedin:   / parnika-tutorials-a8a9831b2
Pinterest:   / parnikatutorials0892
Playlists:
Virtual Coffee with Jagadeesh:
   • VIRTUAL COFFEE WITH JAGADEESH
Digital Logic Design:
   • Digital Logic Design
Computer Organization and Architecture:
   • ABOUT PARNIKA TUTORIALS
C Programming:
   • L 1: WHAT IS AN ALGORITHM AND CHARACT...
Data Structures:
   • L 1: Uncover the Benefits of Linked L...

Theory of Computation:
   • ABOUT PARNIKA TUTORIALS

Compiler Design:
   • ABOUT PARNIKA TUTORIALS
Operating Systems:    • PROCESS STATE DIAGRAM | LONG TERM, SH...

Databases:    • ABOUT PARNIKA TUTORIALS

Computer Networks:
   • ABOUT PARNIKA TUTORIALS
For GATE PYQs and much more explore:
   / parnikatutorials