Re: ASCII Char function

From: Pullikol Kumar <pullikol.kumar_at_mannai.com.qa>
Date: Mon, 12 Nov 2001 04:00:05 -0800
Message-ID: <F001.003C2230.20011112034017@fatcity.com>

Hi Muthu

 Try this PL/SQL , HTH

FUNCTION get_asscii (in_val IN VARCHAR2 ) RETURN VARCHAR2
    IS
     lv_val VARCHAR2(2);
 BEGIN

      SELECT  CHR(in_val)
      INTO   lv_val
      FROM  DUAL
      ;
      RETURN(lv_val);

 EXCEPTION
 WHEN OTHERS THEN
      RETURN (NULL);
END; Pulikkol Nitheesh Kumar. Software Engineer. Mannai Corporation
C.O.S,PO.Box 76.
Doha, Qatar.
Mail id :pullikol dot kumar at mannai dot com Phone : 4412-555 Extn.(363), 4641382 (R). http://mannai dot com dot qa

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Pullikol Kumar
  INET: pullikol.kumar_at_mannai.com.qa

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Mon Nov 12 2001 - 06:00:05 CST