create or replace function test return varchar2 as begin if (8.78 * 100 = 878) then return 'ok'; end if; return 'not ok'; end; / #### SQL> select test from dual; TEST ------------------------------------------------------------------- ok