Tuesday, January 6, 2015

Display currency in Oracle

  select   replace( replace( TO_CHAR ( -14500.77 , 'FML999999D99PR'),'<;',')')  ,'<;','(') from dual;

<$14500.77>
 
Posted by at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)