today:
5,858
yesterday:
8,868
Total:
6,289,255

PL/SQL Study Code

IF ... ELSE

admin 2024.02.02 21:37 Views : 627

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 393
5 OUTER.DECLARE admin 2024.02.03 630
4 %TYPE admin 2024.02.02 605
» IF ... ELSE admin 2024.02.02 627
2 EXCEPTION BLOCK admin 2024.02.02 639
1 OUTPUT SHOWING admin 2024.02.02 620