[Oracle] 오라클 -> MySQL로 전환

1. to_number() ---> cast()

ex) to_number(holiday_mon) --> cast( holiday_mon AS signed )

2. to_char(sysdate,'yyyymmdd')

=> CAST( DATE_FORMAT( now( ) , '%Y%m%d' ) AS CHAR )

3. 년월일시분초

=> CAST( DATE_FORMAT( now( ) , '%Y%m%d%H%i%s' ) AS CHAR )

4. rownum

=>

SELECT @rownum:=@rownum+1 rownum, t.*
FROM (SELECT @rownum:=0) r, mytable t;


5. to_char(balance,'999,999,999,999')
=> format(balance,0)


6. decode
=> case prog_gb_cd
when 1 then '접수'
when 2 then '처리중'
when 3 then '완료'
else '미접수'
end

4. to_char(컬럼, '0000000')
=> LPAD(컬럼,7,'0')