| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> comp.databases.theory -> Re: function's clouser - problem
clouser = closure?
Simple:
CREATE OR REPLACE FUNCTION GET_CL(X IN VARCHAR2) RETURN VARCHAR2 IS
BEGIN
IF X = CL(X) THEN
RETURN X;
ELSE
RETURN(GET_CL(CL(X));
END IF;
END GET_CL;
(NOTE: VARCHAR2 above should be replaced with whatever type X is, and
CL(X) must also have this type... but we knew that, right?)
Received on Thu Apr 21 2005 - 16:46:09 CDT
![]() |
![]() |