Covert Number English to Bangla for Oracle APEX

Covert Number English to Bangla for Oracle APEX

Code

create or replace FUNCTION ennumber2bnnumber (in_value NUMBER) RETURN VARCHAR2 IS p_num VARCHAR2 (100) := TO_CHAR (in_value); p_char CHAR (1); o_str NUMBER := 14722982; V_A VARCHAR2 (500); BEGIN /*************************************************** * This function was created by Md. Arif Hossain * ***************************************************/ FOR i IN 1 .. LENGTH (p_num) LOOP p_char := SUBSTR (p_num, i, 1); IF p_char = '.' THEN o_str := 46; ELSE o_str := 14722982 + TO_NUMBER (p_char); END IF; V_A := V_A || CHR (o_str); END LOOP; -- 14722982. RETURN V_A; END;



Video Link: https://youtu.be/QE5yjACicAs

Output