Re: Ora newbi question (whenever someone finds time)

Open sqlplus,

SQL> select (2*2/5)+1 from dual;

 (2*2/5)+1

       1.8

Then, you can simply use PERL and the DBI module .... or even PHP ...

 Raffaello

On 9 Jul 2002, Tom wrote:

> Thank you for the quick response, but the issue is, because the
> formula is NOT complex I'm trying to avoid writing a PL/SQL procedure
> to parse this expession if oracle can already evaluate simple string
> expressions.
>
> What would be an easy way (if any) of doing this?
>
> Thanxs
>
>
> > -----Ursprüngliche Nachricht-----
> > Von: Raffaello Galli [mailto:galli_at_molgen.mpg.de]
> > Gesendet: Dienstag, 9. Juli 2002 10:51
> > An: Thomas Alexander
> > Betreff: Re: Ora newbi question (whenever someone finds time)
> >
> >
> > Yes, it's possible.
> > You could even use a stored procedure, this solution is the
> > best if the
> > formula is complex.
> >
> > greetings
> >
> > Raffaello
> >
> > On 9 Jul 2002, Tom wrote:
> >
> > > 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:
>
Received on Tue Jul 09 2002 - 07:00:08 CDT