Re: avoid dynamic SQL

From: Randolf Geist <info_at_sqltools-plusplus.org>
Date: Thu, 02 Jul 2009 12:06:59 +0200
Message-Id: <695731396_at_web.de>

A quite comprehensive example of such an eval function in PL/SQL can be found here:

http://forums.oracle.com/forums/thread.jspa?threadID=910384&tstart=0&messageID=3527468#3527468

I haven't tested it but I guess it should be sufficient for the simple formulas mentioned here in the thread provided that it works in general.

Regards,
Randolf

Oracle related stuff blog:
http://oracle-randolf.blogspot.com/

SQLTools++ for Oracle (Open source Oracle GUI for Windows): http://www.sqltools-plusplus.org:7676/
http://sourceforge.net/projects/sqlt-pp/

> Instead of constructing the select string every time and running it with
> execute immediate, create a function which:
>
> 1) takes your expression as a bind variable parameter
> 2) tokenizes this expression into individual pieces
> 3) loops through the tokens and performs appropriate calculation (like CASE
> when token1 = '+' THEN result := result + token2 ... etc)
> 4) once looped through all tokens, return final result
>
> This all can be done in PL/SQL...
>
> --
> Tanel Poder
> http://blog.tanelpoder.com

---

Neu: WEB.DE Doppel-FLAT mit Internet-Flatrate + Telefon-Flatrate für nur 19,99 Euro/mtl.!* http://produkte.web.de/go/02/

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Jul 02 2009 - 05:06:59 CDT