Ora newbi question (whenever someone finds time)

From: Tom <t.alexander_at_ads-tec.de>
Date: 9 Jul 2002 01:11:10 -0700
Message-ID: <697dbfee.0207090011.c84040e@posting.google.com>

Hello! An answer to your question
" !!!!I'm new to the Oracle field !!!!

Hi,
Is it possible to perform simple Arithmetic Expressions in SQL? I imagine something like:

> MagicBallCalculateThis '1 + 2 * (3 + 4)';

>----------------------------------------------

> 15

Reason:
An application I am using is sending a Formula in form of a string of characters. In order to evaluate the Formula I would have to parse the formula to validate it, break it down into each arithmetic operater and convert the numeric strings to numbers.

Wish:
If I could send the complete string as an SQL string to Oracle and get the result returned, I would save myself a lot of work since these formulas only contain multiplication, addition and subtraction.

Thanks guys Received on Tue Jul 09 2002 - 03:11:10 CDT