I am trying to subtract a value from a column ADDRESS by using:
select NAME,ADDRESS,ADDRESS-7 from entity where ....
The result returned with the trailing 0 being dropped.
eg: ADDRESS, ADDRESS-7
How can I keep the trailing 0s?
PS: I am using TOAD version 10.6.1.3 as the browser and the ADDRESS column is created as VARCHAR2.
if you want formatted results, then you need to return the math result as text