Wednesday, 9 March 2016

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;



No comments:

Post a Comment