SELECT TO_CHAR (TO_DATE (TRUNC (465.56), 'J'), 'JSP')
|| ' DOLLARS AND '
|| TO_CHAR (TO_DATE (TO_NUMBER (SUBSTR (465.56, INSTR (465.56, '.') + 1)),'J'),'JSP')||' CENTS'
FROM DUAL;
ap_amount_utilities_pkg.ap_convert_numberSELECT TO_CHAR (TO_DATE (TRUNC (465.56), 'J'), 'JSP')
|| ' DOLLARS AND '
|| TO_CHAR (TO_DATE (TO_NUMBER (SUBSTR (465.56, INSTR (465.56, '.') + 1)),'J'),'JSP')||' CENTS'
FROM DUAL;
ap_amount_utilities_pkg.ap_convert_number
被折叠的 条评论
为什么被折叠?