DECLARE
A INT :=30;
BEGIN
IF ( A > 20) THEN
dbms_output.put_line('A IS GRATER THEN 20');
ELSIF ( A < 20) THEN
dbms_output.put_line('A IS LESS THEN 20');
ELSE
dbms_output.put_line('INPUT IS NOT VALID');
END IF;
END;
A IS GRATER THEN 20
DECLARE
A INT :=30;
BEGIN
IF ( A = 20) THEN
dbms_output.put_line('A IS GRATER THEN 20');
ELSIF ( A = 21) THEN
dbms_output.put_line('A IS LESS THEN 20');
ELSE
dbms_output.put_line('INPUT IS NOT VALID');
END IF;
dbms_output.put_line('YOUR NUMBER IS :' || A);
END;
INPUT IS NOT VALID
YOUR NUMBER IS :30
DECLARE
GRADE CHAR(1) :='A';
MARKS NUMBER(2) := 85;
BEGIN
CASE
WHEN GRADE='A' THEN
DBMS_OUTPUT.PUT_LINE('YOUR GRADE IS Excellent');
END CASE;
CASE
WHEN MARKS>80 THEN
DBMS_OUTPUT.PUT_LINE('YOUR MARKS IS ALSO Excellent');
END CASE;
END;
YOUR GRADE IS Excellent
YOUR MARKS IS ALSO Excellent
DECLARE
GRADE CHAR(1) :='A';
MARKS NUMBER(2) := 85;
BEGIN
CASE
WHEN GRADE='A' THEN
DBMS_OUTPUT.PUT_LINE('YOUR GRADE IS Excellent');
WHEN GRADE='B' THEN
DBMS_OUTPUT.PUT_LINE('YOUR GRADE IS GOOD');
END CASE;
CASE
WHEN MARKS>80 THEN
DBMS_OUTPUT.PUT_LINE('YOUR MARKS IS ALSO Excellent');
END CASE;
END;
YOUR GRADE IS Excellent
YOUR MARKS IS ALSO Excellent