Saturday, 11 August 2018

Oracle / PLSQL: IF-THEN-ELSE Statement

SET SERVEROUTPUT ON;

DECLARE
   a number(3) := 100;
   b number(3) := 200;
BEGIN
   IF( a = 100 ) THEN
      IF( b <> 200 ) THEN
         dbms_output.put_line(b);
      END IF;
   END IF;
   dbms_output.put_line(a);
END;

/

No comments:

Post a Comment

AWS Pricing Basics

AWS Pricing Basics: How to Manage Cloud Costs Cloud computing allows businesses to access infrastructure without purchasing all their h...