PLSQL tutorial#18 Deep dive in PLSQL exception - create an exception in oracle database

In this pl slq tutorial, we are going to learn exception oracle pl/sql programming which includes exception creation, exception raise, exception handling
also, we are going to learn how to create your own ( user-defined exception)

This complete PLSQL online training course will give you in-depth knowledge of PLSQL exception.

What is the exception?
The exception is a kind of mechanism which is used to handle any kind of error which is occurred in plsql program

Type of exception :
System-defined exceptions
User-defined exceptions

System-defined exceptions : These errors/exceptions are pre-defined in oracle data
e.g.NO_DATA_FOUND , TOO_MANY_ROWS ,ZERO_DIVIDE ,INVALID_CURSOR

User-defined exceptions: Its user-defined error/exception as per user requirement

Syntax exception handling:

declare
declare some variable.
begin

write you logic

EXCEPTION
WHEN exceptionName1 THEN
Write Logic to handle error;
WHEN exceptionName2 THEN
Write Logic to handle error;
WHEN others THEN
Write Logic to handle error;

end;


Syntax for to create your own exception:
DECLARE
exception_name EXCEPTION;
BEGIN
IF condition THEN
RAISE exception_name;
END IF;
EXCEPTION
WHEN exception_name THEN
statement;
END;

Oracle SQL Complete Tutorial/Training/Course for the beginner:
https://www.youtube.com/watch?v=3v4s3XMw4q0&list=PLiLpmqwkwkCt0QeXD8j7BwIoOaBGBRrZC


follow me on:
Facebook Page:
https://www.facebook.com/Equalconnect-Coach-791404517889358/?modal=admin_todo_tour
https://www.instagram.com/equalconnect/
https://twitter.com/LrnWthR