In this Video, I have explained user defined exception in oracle plsql with example.
What is User Defined Exception
A user-defined exception in Oracle PL/SQL is a custom error that you create to handle specific conditions in your code. You define it in the declarative section, raise it when needed, and handle it in the exception section of your PL/SQL block.
Syntax of User Defined Exception
exception_name EXCEPTION;
How to use User Defined Exception
1-Declare User Defined Exception
2-Raise User Defined Exception
3-Handle User Defined Exception
Some other Video related to PL SQL tutorial.
Oracle PL/SQL Tutorial 32- Exception Handling with Example in PLSQL
• Oracle PLSQL Tutorial 32- Exception Handli...
Oracle PL/SQL Tutorial 31- Parameter Modes in Procedure(IN,OUT,INOUT) with Example
• Oracle PL/SQL Tutorial 31-Parameter Modes ...
Oracle PL/SQL Tutorial 30- Stored Procedure in PLSQL with Example
• Oracle PL/SQL Tutorial 30- Stored Procedur...
Oracle PL/SQL Tutorial 29- Function INOUT Parameter in PLSQL with Example
• Oracle PL/SQL Tutorial 29- Function INOUT ...
--------------------------------------------------------------------------------------------------------
Our Social Link:-
Link (Blogger) :
https://javainhand.com
Link (Facebook Group )
https://www.facebook.com/groups/14521...
Link (Facebook Page)
/ javainhand2017