2. What are Control Structures & IF Statements (Code Samples).html

<pre class="prettyprint linenums">------------------------------IF STATEMENTS--------------------------------
set serveroutput on;
declare
v_number number := 30;
begin
  if v_number &lt; 10 then
    dbms_output.put_line('I am smaller than 10');
  elsif v_number &lt; 20 then
    dbms_output.put_line('I am smaller than 20');
  elsif v_number &lt; 30 then
    dbms_output.put_line('I am smaller than 30');
  else
    dbms_output.put_line('I am equal or greater than 30');
  end if;
end;
---------------------------------------------------------------------------
declare
v_number number := 5;
v_name varchar2(30) := 'Adam';
begin
  if v_number &lt; 10 or v_name = 'Carol' then
    dbms_output.put_line('HI');
    dbms_output.put_line('I am smaller than 10');
  elsif v_number &lt; 20 then
    dbms_output.put_line('I am smaller than 20');
  elsif v_number &lt; 30 then
    dbms_output.put_line('I am smaller than 30');
  else
    if v_number is null then 
      dbms_output.put_line('The number is null..');
    else
      dbms_output.put_line('I am equal or greater than 30');
    end if;
  end if;
end;
---------------------------------------------------------------------------</pre>