
DECLARE
counter INTEGER ; -- initial value is NULL by default
BEGIN
counter := counter + 1; -- NULL + 1 is still NULL
IF counter IS NULL THEN
DBMS_OUTPUT.PUT_LINE('counter is NULL.');
ELSE DBMS_OUTPUT.PUT_LINE(counter);
END IF;
END;
/
| No. | Subject | Author | Date | Views |
|---|---|---|---|---|
| 6 | NEW TABLE | admin | 2025.11.16 | 258 |
| 5 | OUTER.DECLARE | admin | 2024.02.03 | 503 |
| 4 | %TYPE | admin | 2024.02.02 | 479 |
| » | IF ... ELSE | admin | 2024.02.02 | 487 |
| 2 | EXCEPTION BLOCK | admin | 2024.02.02 | 524 |
| 1 | OUTPUT SHOWING | admin | 2024.02.02 | 500 |