Xref: alice comp.databases.oracle.misc:34303 comp.databases.oracle.server:54461 Path: alice!news-feed.fnsi.net!hammer.uoregon.edu!logbridge.uoregon.edu!newsgate.cuhk.edu.hk!news.umac.mo!not-for-mail From: "Chow Hoi Ka, Eric" Newsgroups: comp.databases.oracle.misc,comp.databases.oracle.server Subject: Re: Idea for Rule-Table ? Date: Tue, 22 Jun 1999 17:48:50 +0800 Organization: University of Macau Lines: 65 Message-ID: <376F5C02.7E8D3054@sftw.umac.mo> References: <376E460D.20ECE0D2@sftw.umac.mo> <376FC1C7.88D1D7AC@eurographics.co.uk> Reply-To: d951686@sftw.umac.mo Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Trace: umacss2.umac.mo 930130972 11814 161.64.4.206 (23 Jun 1999 09:42:52 GMT) X-Complaints-To: news@umacss2.umac.mo NNTP-Posting-Date: 23 Jun 1999 09:42:52 GMT To: Dan Richards X-Mailer: Mozilla 4.51 [en] (Win98; I) X-Accept-Language: en 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@sftw.umac.mo \ \_/ ////) > > \ / \ / > > \ _/ http://www.sftw.umac.mo/~d951686/ \_ / > > / / |____________________________________________| \ \ > > / / \ \ -- _ _ / ) |~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ( \ / / | | \ \ _( /_ | _ Chow Hoi Ka, Eric _ | _) )_ (((\ \> |/ ) ( \|