IF - ELSE IN ORACLE PL-SQL

IF - ELSE IN ORACLE PL-SQL

DECLARE
  bonus  NUMBER(8,2) := 50;
  emp_id NUMBER(6) := 100;
BEGIN
  DBMS_OUTPUT.PUT_LINE ('IF ELSE LADDER');
  IF bonus < emp_id
  THEN
    DBMS_OUTPUT.PUT_LINE ('GOOD');
  ELSE
    DBMS_OUTPUT.PUT_LINE ('BAD');
END IF;
END;

Implementation of multiplication table in oracle pl-sql (do while loop)

Implementation of multiplication table in oracle pl-sql (for loop)

DECLARE
   a number(6);
   c number(6);
   b number(6) := 19;
BEGIN
   dbms_output.put_line('Multiplication table for 19 table is (implemented using for loop):');
   FOR a in 1 .. 10 LOOP
       c := b*a;
       dbms_output.put_line( b || ' * ' || a || ' = ' || c );
  END LOOP;
END;