select case when 10>1 then 'True' else 'False' end flag from dual
SQL> create or replace function fun_flag(condition in varchar2)return varchar2 2 as 3 v number; 4 begin 5 execute immediate 'select case when '||condition||' then 1 else 0 end from dual' 6 into v; 7 if v=1 then return 'True'; 8 else return 'False'; 9 end if; 10 end fun_flag; 11 /
2 as
3 v number;
4 begin
5 execute immediate 'select case when '||condition||' then 1 else 0 end from dual'
6 into v;
7 if v=1 then return 'True';
8 else return 'False';
9 end if;
10 end fun_flag;
11 /
Function created
SQL> select fun_flag(
2 '10<1') from dual
3 ;
FUN_FLAG('10<1')
--------------------------------------------------------------------------------
False
SQL>
from dual;