Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Idea for Rule-Table ?
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