if <condition> then
...<<set of statements>>...
elsif <condition> then
...<<set of statements>>...
elsif <condition> then
...<<set of statements>>... else
...<<set of statements>>... end if;
SQL>
SQL> create or replace function f_isSunday (in_dt DATE)
2 return VARCHAR2
3 is
4 v_out VARCHAR2(10);
5 begin
6 if to_char(in_dt,'d')=1 then
7 v_out:='Y';
8 else
9 null;
10 end if;
11 return v_out;
12 end;
13 /
SP2-0806: Function created with compilation warnings