Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: function's clouser - problem

Re: function's clouser - problem

From: <casey.kirkpatrick_at_gmail.com>
Date: 21 Apr 2005 14:46:09 -0700
Message-ID: <1114119969.673786.19580@g14g2000cwa.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US