SQL Plus - WHENEVER SQLERROR

1 - About

It performs the specified action (exits SQL*Plus by default) if a SQL command or PL/SQL block generates an error.

3 - Syntax


WHENEVER SQLERROR 
     {
        EXIT [SUCCESS|FAILURE|WARNING|n|variable|:BindVariable][COMMIT|ROLLBACK] 
        | 
        CONTINUE [COMMIT|ROLLBACK|NONE]
     }

where:

4 - Example


WHENEVER SQLERROR EXIT SQL.SQLCODE ROLLBACK


Data Science
Data Analysis
Statistics
Data Science
Linear Algebra Mathematics
Trigonometry

Powered by ComboStrap