in Oracle by
Q:
Q. How to handle errors in PL/SQL?

▼ Show 1 Answer

0 votes
by

In PL/SQL, an error condition is called an exception and PL/SQL errors are handled using the EXCEPTION block. The syntax for handling exceptions is written below:
DECLARE
...
BEGIN
...
EXCEPTION
WHEN exception1 THEN
...
WHEN exception2 THEN
...
WHEN others THEN
...
END;

Learn More with Madanswer

Related questions

0 votes
asked Jul 29, 2020 in Oracle by Hodge
+1 vote
asked Mar 7 in PL/SQL by SakshiSharma
...