Number Formatting

[Stang02GT]

I am trying to get negative numbers to display as (1,23)

the current format is as follows...

'9G990D00', 'NLS_NUMERIC_CHARACTERS = '',.''

If I edit 9G990D00 to (9G990D00) would that do it?

[r035198x]

I am trying to get negative numbers to display as (1,23)

the current format is as follows...

'9G990D00', 'NLS_NUMERIC_CHARACTERS = '',.''

If I edit 9G990D00 to (9G990D00) would that do it?

The dirty thoughts going in my head right now yield
[CODE=mysql]select replace (replace (to_char('-5000.8','9999.9 9PR'), '<', '('), '>', ')') from dual[/CODE]

[Stang02GT]

The dirty thoughts going in my head right now yield
[CODE=mysql]select replace (replace (to_char('-5000.8','9999.9 9PR'), '<', '('), '>', ')') from dual[/CODE]

That worked nicely. Thanks very much! :)

[amitpatel66]

Try this as well:

[code=oracle]

SELECT '('||TO_CHAR(-5000.8 * -1,'9999.99')||' )' FROM dual

[/code]

[r035198x]

Try this as well:

[code=oracle]

SELECT '('||TO_CHAR(-5000.8 * -1,'9999.99')||' )' FROM dual

[/code]

That would work only for negative numbers?

[amitpatel66]

That would work only for negative numbers?

Yap. the OP wanted to display the negative numbers in that particular format.
Btw, the best way would be:

[code=oracle]

SELECT '('||TO_CHAR(AB S(-5800.0),'9999.9 9')||')' from dual

[/code]

[r035198x]

..Btw, the best way would be:

[code=oracle]

SELECT '('||TO_CHAR(AB S(-5800.0),'9999.9 9')||')' from dual

[/code]

Not unless they have both negative and positive numbers and want to format their negative numbers that way.