목록숫자 (2)

not set

금액에 콤마찍어서 반환하는 펑션

CREATE OR REPLACE FUNCTION HS_AP.fc_hs_getComma ( P_AMT IN NUMBER -- 금액 ) RETURN VARCHAR2 IS /************************************************************************** ** DESC: 금액에 천원단위로 콤마를 찍어서 반환하기 ** P_AMT : 금액 ** ** AUTH: bearpro ** DATE: 2010/07/23 *************************************************************************** ** CHANGE HISTORY *************************************************..
Database/pl-sql 2010. 7. 23. 11:17
Oracle 숫자 콤마찍기.

SELECT TO_CHAR(123124657897111,'FM999,999,999,999,999') FROM DUAL 123,124,657,897,111
Database/query 2010. 7. 13. 12:47
이전 Prev 1 Next 다음