| Format of number [message #261668] |
Thu, 23 August 2007 05:22  |
dimis283
Messages: 38
Registered: July 2007
Location: greece
|
Member |
|
|
I have a rather simple question.
I have a sum of columns at a query and I want to put this sum at a label (as &sum).
How can I change the format of this number, I know at text fields I will give the "NGNNNGNN0D00" format but at labels how can I do it?
With to_number function maybe at query, but how can I do it?
|
|
|
|
|
|
| Re: Format of number [message #261679 is a reply to message #261668] |
Thu, 23 August 2007 05:42  |
dimis283
Messages: 38
Registered: July 2007
Location: greece
|
Member |
|
|
At Label of reports we write text.
I want to write something like "The sum is &sum" and I want to give a format to this number not knowing the digits of the number.
I may give format at query but how, the examples I saw give numbers with known digits.
-----
edit
-----
At now I give this at query
SELECT to_char(255210.73, '999G999G999G999D99') FROM DUAL
[Updated on: Thu, 23 August 2007 05:52] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
