Oracle Database - Dynamic SQL - TechRepublic
General discussion
February 28, 2001 at 11:02 AM
jenni

Oracle Database – Dynamic SQL

by jenni . Updated 25 years, 3 months ago

I want ot be able to store a formula as a string in the database and then
apply it to calculate a price.

The problem I’m having is that Oracle does not seem to recognise the + * /
or – operators when in a char string.
Example
Char string(3 * 30) / (2*5) returns ‘ (3 * 30) / (2*5)’ and not 9

Can anyone help me solve this problem?

This discussion is locked

All Comments