A Function of selecting the contents of a ref cursor as part of a SQL Select statement


CREATE OR REPLACE
FUNCTION TESTFUNCTION RETURN sys_refcursor
IS
c1 sys_refcursor;
BEGIN
open c1 for select * from regions;
  return c1;
END TESTFUNCTION;


Comments

Popular posts from this blog

Solution for "Can not obtain Oracle client information from registry"

Solution for the fault: "System.Diagnostics.Process.Start is not working on IIS, but working on ASP.NET Development Server"