Advertisement
Guest User

Untitled

a guest
Sep 24th, 2020
42
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.19 KB | None | 0 0
  1. SELECT
  2.   decode(trunc(nmbr),nmbr,to_char(nmbr,'fm99999999999999999999'),to_char(nmbr,'fm99999999999999999999D99999')) output
  3. FROM (SELECT 123.9 nmbr FROM dual UNION ALL SELECT 123 nmbr FROM dual);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement