In PL/SQL, the CASE statement is used to perform conditional logic within your SQL queries and PL/SQL blocks. It allows you to evaluate a condition and execute a specific block of code based on the result of that condition. Syntax of CASE in PL/SQL:…