How to add exception in the oracle statement?

@wilmer.lemke 

To add an exception in an Oracle SQL statement, you can use the EXCEPTION block in a PL/SQL block. Here is an example:

1
2
3
4
5
6
7
8

BEGIN
   INSERT INTO my_table (column1, column2)
   VALUES ('value1', 'value2');
EXCEPTION
   WHEN OTHERS THEN
      -- Handle the exception here
      DBMS_OUTPUT.PUT_LINE('An error occurred: ' || SQLERRM);
END;

In this example, if an exception occurs during the execution of the INSERT statement, the EXCEPTION block will be triggered and the error message will be displayed using the DBMS_OUTPUT.PUT_LINE procedure.

You can customize the handling of different exceptions by adding specific WHEN clauses for each type of exception you want to handle.