jmagnus@prod01> select 100000 thenumber from dual; THENUMBER ---------- 100000 jmagnus@prod01> col thenumber format 999,999 jmagnus@prod01> / THENUMBER --------- 100,000