Hi Muthu
Try this PL/SQL , HTH
FUNCTION get_asscii (in_val IN VARCHAR2 )
RETURN VARCHAR2
IS
lv_valVARCHAR2(2);
BEGIN
SELECT CHR(in_val)
INTO lv_val
FROM DUAL
;
RETURN(lv_val);
EXCEPTION
WHEN OTHERS THEN
RETURN (NULL);
END;
Pulikkol
Hi Muths,
There is chr() function in PL/SQL. For example "select
chr(65) from dual" will give you the corresponding
ascii character.
I hope this answers your question.
Regards,
Prasad BAV.
--- Muthaiah <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I am writing a program to get the ASCII character by