Hi,
I have an amount field in a table as Number. How do I fetch this field in a definitive decimal place value? Number of decimal places are configured in a table. lets say 6.
So if the value is 123.12 result should be 123.120000
if the value is 123.1234567, result should be 123.123456.
I know of to_char but that will require predefined format where is my format can change based on what's stored in configuration table for decimal place value.
Thanks