How to retrieve negative value as positive in simple brackets? [message #664291] |
Tue, 11 July 2017 06:59 |
|
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.
|
|
|
|
|
|
|
|