1

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 think it depends what the functions does. if it's simple, then we have some options, some Oracle DBMS packages, built-in functions. – Jakub P Aug 27 at 20:33
2

Create the functions within a PACKAGE.

Beyond that, you are using a feature that was introduced in 12c.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.