I'm having a issue of a variable I'm setting in my PL/SQL Program. I'm subtracting two Number Data types and dividing those by the lower number to get a percent change. Now, for instance, that number is a 2.5. How can I assign that to it's correct value in the variable of .25?
Thanks for you help!
Example:
PRICEDIFF := (PRICE1 - PRICE2) / PRICE2