Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Idea for Rule-Table ?

Re: Idea for Rule-Table ?

From: Dan Richards <dan_at_eurographics.co.uk>
Date: Tue, 22 Jun 1999 18:03:03 +0100
Message-ID: <376FC1C7.88D1D7AC@eurographics.co.uk>


Hi Eric

I've done something similar by storing the "rules" as SQL criteria strings in a table, and then using the dynamic sql package DBMS_SQL to build statements that can be executed...

Dan

"Chow Hoi Ka, Eric" wrote:

> Hello,
>
> I am a programmer using Oracle and PL/SQL for programminig.
>
> I am now doing some par that the purpose is that,
> There is a Table for store all the RULES.
>
> So, I need to write a PL/SQL store procedure to get some rules from that
> Table for validation.
>
> Any idea of that ? Is there any developer having this kind of experience
> ? Please teach me.
> Or give me some idea of that.
>
> I also wonder how is ths structure of that Rule Table !!!
>
> Best regards,
> Eric
>
> --
> _ _
> / ) |~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ( \
> / / | | \ \
> _( /_ | _ Chow Hoi Ka, Eric _ | _) )_
> (((\ \> |/ ) ( \| </ /)))
> (\\\\ \_/ / E-Mail : d951686_at_sftw.umac.mo \ \_/ ////)
> \ / \ /
> \ _/ http://www.sftw.umac.mo/~d951686/ \_ /
> / / |____________________________________________| \ \
> / / \ \
Received on Tue Jun 22 1999 - 12:03:03 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US