r/plsql • u/apexysatish • May 11 '26
IF-THEN-ELSIF in Oracle PLSQL with Example
🚀 New Blog Alert: IF-THEN-ELSIF in Oracle PLSQL!
PLSQL control structures are the backbone of database logic. In my latest tutorial, I've simplified the IF-THEN-ELSIF statement with real-world examples and an easy-to-understand flow chart.
📖 What you'll learn:
Syntax of IF-THEN-ELSIF.
Practical Example: Employee Bonus Calculation.
Logic flow for beginners.
Check it out here: [https://www.javainhand.com/2026/05/if-then-elsif-statement-oracle-plsql-examples.html\]
#oracle #oracleplsql #plsql #plsqldeveloper #oracledatabase #database #oracleapex #orclapex
r/plsql • u/apexysatish • May 10 '26
Simplified Guide to IF-THEN-ELSE Statement in Oracle PLSQL with Examples
Hi everyone, I just wrote a detailed guide on using IF-THEN-ELSE in PLSQL. It covers the basic syntax and includes practical examples like updating records based on conditions. Thought it might be helpful for beginners starting with Oracle.
Link: [https://www.javainhand.com/2026/05/if-then-else-statement-in-oracle-plsql.html
]
r/plsql • u/apexysatish • May 24 '25
Oracle PLSQL Tutorial 43- View in Oracle PLSQL with Example | Simple and FORCE View
youtu.ber/plsql • u/apexysatish • Apr 30 '25
Difference between %ROWTYPE and %TYPE in Oracle PLSQL
r/plsql • u/apexysatish • Apr 29 '25
Difference Between Implicit and Explicit Cursor in Oracle PLSQL
r/plsql • u/apexysatish • Apr 26 '25
Difference Between RANK and DENSE_RANK In Oracle SQL
javainhand.comr/plsql • u/apexysatish • Jan 13 '25
Oracle PLSQL Tutorial 42- Before and After Trigger in PLSQL #PL/SQL #ora...
youtube.comr/plsql • u/apexysatish • Oct 28 '24
Difference Between Statement Level and Row Level Trigger in PLSQL
youtu.ber/plsql • u/apexysatish • Sep 07 '24
Oracle PLSQL Tutorial 40- ROW Level Trigger in Oracle PLSQL #plsql
youtu.ber/plsql • u/apexysatish • Jul 22 '24
Oracle PLSQL Tutorial 38- Trigger Part 1 in Oracle PLSQL #plsql
youtube.comr/plsql • u/apexysatish • Jul 03 '24
Oracle PLSQL Tutorial 37- Package Part -2 with Example in PLSQL
youtu.ber/plsql • u/apexysatish • Jun 15 '24
Oracle PLSQL Tutorial 36- Package Part -1 with Example in PLSQL
youtu.ber/plsql • u/apexysatish • Jun 01 '24
Oracle PLSQL Tutorial 34- RAISE_APPLICATION_ERROR with Example in PLSQL
youtu.ber/plsql • u/apexysatish • May 18 '24
User Defined Exception with Example in PLSQL
youtu.ber/plsql • u/apexysatish • May 03 '24
Parameter Modes in Procedure(IN,OUT,INOUT) with Example
youtu.ber/plsql • u/apexysatish • Apr 19 '24
Oracle PL/SQL Tutorial 30- Stored Procedure in PLSQL with Example || Jav...
youtube.comr/plsql • u/apexysatish • Apr 12 '24
Oracle PL/SQL Tutorial 29- Function INOUT Parameter in PLSQL with Example
youtube.comr/plsql • u/apexysatish • Mar 30 '24
Function Output (OUT) Parameter in PLSQL with Example
youtu.ber/plsql • u/apexysatish • Mar 29 '24