Re: How to create a function to evaluate numeric expression
You could write a function to parse the string as a calculator would, but since functions are restricted to the most literal-minded SQL execution, that'd be like trying to teach a dog to play chess.
What's the point of this exercise? Select (12+45+8)/10 returns exactly what you need.
Subject
Written By
Posted
December 18, 2014 05:16AM
Re: How to create a function to evaluate numeric expression
December 18, 2014 10:05AM
December 18, 2014 10:18AM
December 18, 2014 11:09AM
December 18, 2014 04:57PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.