How to retrieve negative value as positive in simple brackets? [message #664291] |
Tue, 11 July 2017 06:59 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/39c38311c08c8486dd03002ae1044dec?s=64&d=mm&r=g) |
oracbeg
Messages: 16 Registered: July 2017
|
Junior Member |
|
|
Can anybody please help me with this? Is there any function or any way where i can customise the output negative numeric value as positive and in brackets. For eg: the output value should come in form of (123) from -123. i have tried to_char function along with numeric formatting {TO_CHAR(round(-123, '999PR')} it gives output in angular brackets like <123> but i want it as (123) in simple brackets.
|
|
|
|
|
|
|
|