Rafiuddin - Oracle EBS Techo-Functional
HCM, Finance, SCM, BI (OBIEE & Discoverer), Workflow, D2K, OAF, ADF, XML, AME, SSHR, FSG, API, DBA
Tuesday, September 30, 2014
Function for converting Number to Words
Syntax:
---------
TO_CHAR
(
TO_DATE
(<VALUE>,
'j'
),
'jsp'
)
eg
:
SELECT
(
TO_CHAR
(
TO_DATE
(4566,
'j'
),
'jsp'
)) num_to_words
FROM
DUAL;
Output
: four thousand five hundred sixty-six
Newer Post
Older Post
Home