Guest User

Untitled

a guest
May 20th, 2018
125
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.23 KB | None | 0 0
  1. select to_char(a, '99D90') test1,
  2. to_char(a, '90D90') test2,
  3. to_char(a, 'FM90D99') test3,
  4. rtrim(to_char(a, 'FM90D99'), to_char(0, 'D')) test4
  5. from (
  6. select 50 a from dual
  7. union all select 50.57 from dual
  8. union all select 5.57 from dual
  9. union all select 0.35 from dual
  10. union all select 0.4 from dual
  11. union all select 0.80 from dual
  12. union all select .88 from dual
  13. )
  14. order by a;
  15.  
  16. TEST1 TEST2 TEST3 TEST4
  17. ------ ------ ------ ------
  18. .35 0.35 0.35 0.35
  19. .40 0.40 0.4 0.4
  20. .80 0.80 0.8 0.8
  21. .88 0.88 0.88 0.88
  22. 5.57 5.57 5.57 5.57
  23. 50.00 50.00 50. 50
  24. 50.57 50.57 50.57 50.57
  25.  
  26. SQL> WITH DATA AS(
  27. 2 select 50 a from dual
  28. 3 union all select 50.57 from dual
  29. 4 union all select 5.57 from dual
  30. 5 union all select 0.35 from dual
  31. 6 union all select 0.4 from dual
  32. 7 UNION ALL SELECT 0.80 FROM dual
  33. 8 UNION ALL SELECT .88 FROM dual
  34. 9 )
  35. 10 SELECT
  36. 11 CASE
  37. 12 WHEN TRUNC(A) = 0
  38. 13 THEN ltrim(to_char(a, '0D99'), ' ')
  39. 14 ELSE TO_CHAR(a)
  40. 15 END text
  41. 16 FROM DATA;
  42.  
  43. TEXT
  44. ----------------------------------------
  45. 50
  46. 50.57
  47. 5.57
  48. 0.35
  49. 0.40
  50. 0.80
  51. 0.88
  52.  
  53. 7 rows selected.
  54.  
  55. SQL>
Add Comment
Please, Sign In to add comment