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_number
posted on 2014-08-09 21:17 王小航 阅读(265) 评论(0) 编辑 收藏 举报