Pages

Thursday, January 1, 2015

Query to Get Amount in Arabic



SQL Query to Get Amount in Arabic

/* Formatted on 1/1/2015 4:53:21 PM (QP5 v5.215.12089.38647) */

SELECT :digits source_digits,
           REPLACE (
              SYS_CONNECT_BY_PATH (UNISTR ('\066' || SUBSTR (:digits, LEVEL, 1)), '~'), '~')   translated_digits
      FROM DUAL
     WHERE CONNECT_BY_ISLEAF = 1
CONNECT BY LEVEL <= LENGTH (:digits);

No comments:

Post a Comment