I am attempting to write a Oracle statement that takes two existing database objects and performs some simple math to create dynamic variable.
decode(wdj.attribute14 / wdj.attribute15, 0, 0) cpr
from wip.wip_discrete_jobs wdj
I have been playing with the above code and cannot seem to figure it out.
I would like to divide ATTRIBUTE14 and ATTRIBUTE15 and name the new column CPR...