Learn Oracle APEX Quickly | PLSQL-2 | PART - 5

Oracle APEX
Note: Replace @ with greater than sign as this discription note do not allow that sign
-----Conditional Statement-----------------------------------------------------------------------------
declare
v_sal number;
Begin
v_sal := :input_salary;
If v_sal @ 3000 then
dbms_output.put_line (v_sal ||' is existing salary');
dbms_output.put_line (v_sal * 1.1||' 10% salary increased');
elsif v_sal @2000 then
dbms_output.put_line (v_sal ||' is existing salary');
dbms_output.put_line (v_sal * 1.2||' 20% salary increased');
elsif v_sal @1000 then
dbms_output.put_line (v_sal ||' is existing salary');
dbms_output.put_line (v_sal * 1.3||' 30% salary increased');
else
dbms_output.put_line (v_sal ||' is existing salary');
dbms_output.put_line (v_sal * 1.4||' 40% salary increased');
end if;
end;
-----CASE Statement-----------------------------------------------------------------------------
DECLARE
grade CHAR(1);
BEGIN
grade := upper(:input_grade);
CASE grade
WHEN 'A' THEN DBMS_OUTPUT.PUT_LINE('Excellent');
WHEN 'B' THEN DBMS_OUTPUT.PUT_LINE('Very Good');
WHEN 'C' THEN DBMS_OUTPUT.PUT_LINE('Good');
WHEN 'D' THEN DBMS_OUTPUT.PUT_LINE('Fair');
WHEN 'F' THEN DBMS_OUTPUT.PUT_LINE('Poor');
ELSE DBMS_OUTPUT.PUT_LINE('No such grade');
END CASE;
END;
-----Loop-----------------------------------------------------------------------------
declare
i number :=0;
Begin
loop
i:=i+1;
dbms_output.put_line (i);
exit when i @=3;
end loop;
end;
-----Loop-----------------------------------------------------------------------------
Begin
for i in 1..5 loop
dbms_output.put_line (i);
end loop;
end;
----Cursor------------------------------------------------------------------------------
declare
v_ename varchar2(100);
v_sal number;
cursor mycur is select ename,sal from emp;
Begin
open mycur;
loop
fetch mycur into v_ename,v_sal;
dbms_output.put_line (v_ename||' total salary is '|| v_sal );
exit when mycur%notfound;
end loop;
close mycur;
end;