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

select replace (replace (to_char('-5000.8','9999.99PR'), '<', '('), '>', ')') from dual

[Stang02GT]

The dirty thoughts going in my head right now yield

select replace (replace (to_char('-5000.8','9999.99PR'), '<', '('), '>', ')') from dual

That worked nicely. Thanks very much! :)

[amitpatel66]

Try this as well:

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

[r035198x]

Try this as well:

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

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:

 
SELECT '('||TO_CHAR(ABS(-5800.0),'9999.99')||')' from dual
 
 

[r035198x]

..Btw, the best way would be:

 
SELECT '('||TO_CHAR(ABS(-5800.0),'9999.99')||')' from dual
 
 

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