create or replace function fff(p_id varchar2) return varchar2 is l_pp varchar2(20); begin execute immediate 'select ''x'' from dual' INTO l_pp; RETURN l_pp; end fff; SQL> select fff('') from dual;FFF('') -------------------------------------------------------------------------------- x
l_pp varchar2(20);
begin
execute immediate 'select ''x'' from dual' INTO l_pp;
RETURN l_pp;
end fff;
SQL> select fff('') from dual;FFF('')
--------------------------------------------------------------------------------
x