Home » RDBMS Server » Server Administration » How to format Number
How to format Number [message #372001] Wed, 03 January 2001 07:38 Go to next message
sri
Messages: 154
Registered: February 2000
Senior Member
hi,

I want to format the number while displaying.

for eg. 1234546 will be displayed as 1,234,546.

Please suggest if there any to get this through SQL statement

Report message to a moderator

Re: How to format Number [message #372004 is a reply to message #372001] Wed, 03 January 2001 08:21 Go to previous messageGo to next message
Bala
Messages: 205
Registered: November 1999
Senior Member
Hi,
From sql plus......
SQL> column column_name format 9,999,999;
SQL> select column_name from t1;
1,234,567

using just sql.....
SQL> select to_char(column_name, '9,999,999') from t1;

Report message to a moderator

Re: How to format Number [message #372017 is a reply to message #372004] Wed, 03 January 2001 14:46 Go to previous message
sverch
Messages: 582
Registered: December 2000
Senior Member
SQL>SET NUMFORMAT 9,999,999

Report message to a moderator

Previous Topic: Problem with Designer
Next Topic: How to get connected for the first time ???
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu May 16 21:10:06 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.