Re: Idea for Rule-Table ?

Hi Dan,

I am very happy you had this kind of experience. Would you please to teach me how to implement this ? Would you please to give me some examples ????

Best regards,
Eric

Dan Richards wrote:

> 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/ \_ /
> > / / |____________________________________________| \ \
> > / / \ \

--

     _                                                  _
    / ) |~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ( \
   / /  |                                            |  \ \
 _( /_  | _   Chow Hoi Ka, Eric                    _ |  _) )_
(((\ \> |/ )                                      ( \| </ /)))
(\\\\ \_/ /   E-Mail : d951686_at_sftw.umac.mo        \ \_/ ////)
 \       /                                          \        /
  \    _/     http://www.sftw.umac.mo/~d951686/      \_     /
  /   / |____________________________________________| \    \
 /   /                                                   \    \