Home » SQL & PL/SQL » SQL & PL/SQL » format number column for display ..
format number column for display .. [message #218386] Wed, 07 February 2007 23:57 Go to next message
frank.svs
Messages: 162
Registered: February 2006
Senior Member
Hi pals,

There is a small requirement. I need to display the amt values in million's format.
What could be the SELECT stmt for it.



create table test
(
amt number
)

insert into test values(100000000)
insert into test values(10000000)
insert into test values(1000000)
insert into test values(100000)

I need the output as follows
100,000,000
10,000,000
1,000,000
100,000


Any solution.
Thanks in advance.

frank
Re: format number column for display .. [message #218391 is a reply to message #218386] Thu, 08 February 2007 00:37 Go to previous messageGo to next message
rleishman
Messages: 3724
Registered: October 2005
Location: Melbourne, Australia
Senior Member
./fa/1622/0/ <--Click
Re: format number column for display .. [message #218396 is a reply to message #218391] Thu, 08 February 2007 00:52 Go to previous message
pavuluri
Messages: 247
Registered: January 2007
Senior Member
SELECT TO_CHAR(amt,'999G999G999G999G999G999') "Amount" FROM test3;
Thanks
Srinivas
Previous Topic: Insert Blank to a not null column
Next Topic: connection problem
Goto Forum:
  


Current Time: Sun Dec 04 00:25:02 CST 2016

Total time taken to generate the page: 0.23577 seconds