How to Create a Function in Oracle


CREATE OR REPLACE
FUNCTION TESTBYNAME2(XKENTLI_AD VARCHAR2) 
RETURN VARCHAR2
IS
    XBABAADI VARCHAR2(50);
BEGIN
    SELECT BABA_ADI INTO XBABAADI FROM ORT_KENTLI WHERE ADI=XKENTLI_AD AND ROWNUM=1;
      IF xbabaadi='MEHMET' THEN
        XBABAADI:='KASIM';
      END IF;
RETURN XBABAADI;

END;

Comments

Popular posts from this blog

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

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