Problem in createing a simple function

• • Reply

  14 years ago

  by windshadow2005

  Rajesh Kumar

  , India

  Joined 16 years ago

  Hai..

  I have got a simple problem for Oracle Guru. I am createing a simple function for checking the gender from the database. In my database i have saved M for Male & F for Female. But when I will display it to the user it should show Male/Female. For that I have create a function... which is given below. I am unable to create the function. Please Help me out

   

  CREATE OR REPLACE FUNCTION FN_GENDER(GTYPE VARCHAR2) RETURN VARCHAR2 IS
  ARGS VARCHAR2;
  BEGIN
   IF GTYPE='M' THEN
     ARGS := MALE;
     RETURN ARGS;
   ELSE
     ARGS := FEMALE;
     RETURN ARGS;
   ENS IF;
  END;
  
  
  
  
  
  
  
  
  
  

   

  Thanks a lot in advance.

  Report abuse
• • Reply

  14 years ago

  by lexian

  Alexis Méndez

  , Puerto Rico

  Joined 14 years ago

  Try this one:

  CREATE OR REPLACE FUNCTION FN_GENDER(GTYPE VARCHAR2) RETURN VARCHAR2 IS
  ARGS VARCHAR2;
  BEGIN
   IF (GTYPE='M') THEN
     ARGS := 'MALE';
     RETURN ARGS;
   ELSE
     ARGS := 'FEMALE';
     RETURN ARGS;
   END IF;
  END;
  
  
  
  
  
  
  
  
  
  

  Or this:

  CREATE OR REPLACE FUNCTION GENDER(g VARCHAR2)
     RETURN NUMBER DETERMINISTIC IS
  BEGIN
    IF (g='M') THEN
     RETURN 'MALE';
   ELSE
     RETURN 'FEMALE';
   END IF;
  END;
  
  
  
  
  
  
  
  

  I didn’t test them.

  Report abuse
• • Reply

  14 years ago

  by windshadow2005

  Rajesh Kumar

  , India

  Joined 16 years ago

  Thanks a lot..

  I have try the following code with a littlt bit changing. & it works fine now..

   

  CREATE OR REPLACE FUNCTION FN_GENDER(GTYPE VARCHAR2) RETURN VARCHAR2 IS
  ARGS VARCHAR2(6);
  
  BEGIN
   IF (GTYPE='M') THEN
     ARGS := 'MALE';
     RETURN ARGS;
   ELSE
     ARGS := 'FEMALE';
     RETURN ARGS;
   END IF;
  END;
  
  
  
  
  
  
  
  
  
  
  

  Thanks again a lot.

  Report abuse
• • Reply

  14 years ago

  by windshadow2005

  Rajesh Kumar

  , India

  Joined 16 years ago

  Hai

   

  But when I am trying to create function using if-else-if. It shows me the error

  Here are the codes

  create or replace FUNCTION FN_USTS(GTYPE VARCHAR2) RETURN VARCHAR2 IS
  ARGS VARCHAR2(20);
  BEGIN
   IF (GTYPE='S') THEN
     ARGS := 'Short Listed';
     RETURN ARGS;
   ELSEIF (GTYPE='R') THEN
     ARGS :='Rejected';
     RETURN ARGS;
   ELSE
     ARGS := 'Probable';
     RETURN ARGS;
   END IF;
  END;
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  

  Thanks a lot

  Report abuse
• • Reply

  14 years ago

  by lexian

  Alexis Méndez

  , Puerto Rico

  Joined 14 years ago

  Hi,

  Try this one:

  create or replace FUNCTION FN_USTS(GTYPE VARCHAR2) RETURN VARCHAR2 IS
  ARGS VARCHAR2(20);
  BEGIN
   IF (GTYPE='S') THEN
    ARGS := 'Short Listed';
      RETURN ARGS;
   ELSE
   IF (GTYPE='R') THEN
       ARGS :='Rejected';
       RETURN ARGS;
    ELSE
       ARGS := 'Probable';
       RETURN ARGS;
   END IF;
   END IF;
  END;
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  

  Report abuse
• • Reply

  14 years ago

  by windshadow2005

  Rajesh Kumar

  , India

  Joined 16 years ago
  Thanks a lot .
  Report abuse