Wrong execution under Debugger

Hello!

I have executed below code under debugger (step by step) and I have very interesting result.
Try!!!

create or replace function Mart_s return number is  num number;
begin
 select count(*) into num from dual;
 if num = 1 then -- 1 start
  select count(*) into num from dual;
  if num = 1 then -- 2 start
   commit;
   select count(*) into num from dual;
   commit;
  else -- 2 else
   if num = 1 then -- 3 start
    select count(*) into num from dual;
   end if; -- 3 end;
  end if; -- 2 end;
 else -- 1 else;
  null;
 end if; -- 1 end;
 return num;
end;

May be Anybody can explain me this result.

Best regards,
Sergey M. Received on Thu May 30 2002 - 12:12:34 CDT