I am using (with function) in oracle 12c  . in 11g this is not available. Is there any other way we can implement with function in 11g .

with function x(p_NUM in number) return number is n number; begin SELECT 1 INTO N FROM DUAL; -- return N; -- end ;

function Y(p_NUM in number) return number is N1 NUMBER; begin SELECT 2 INTO N1 FROM DUAL; -- return N1; -- end ;

select X(1), Y(1) from dual;

I am using (with function) in Oracle 12c. in 11g this is not available. Is there any other way we can implement with function in 11g?

with 
  function x(p_NUM in number) return number
  is
    n number;
  begin
    SELECT 1 INTO N FROM DUAL;
    --
    return N;
    --
  end ; 
  --      
  function Y(p_NUM in number) return number
  is 
    N1 NUMBER;
  begin
    SELECT 2 INTO N1 FROM DUAL;
    --
    return N1;
    --
  end ; 
--
select X(1), Y(1)
from dual;