Thread: inserting the thousand seperator (,) in the output of a query
View Single Post
  #5 (permalink)  
Old 06-29-09, 17:37
The_Duck The_Duck is offline
Registered User
  
Join Date: Jul 2003
Posts: 2,292
PHP Code:
jmagnus@prod01> select 100000 thenumber from dual;

 THENUMBER
----------
    100000

jmagnus@prod01> col thenumber format 999,999
jmagnus@prod01> /

THENUMBER
---------
  100,000 
__________________
- The_Duck
you can lead someone to something but they will never learn anything ...
Reply With Quote