Re: Create Rule

What you essentially need to do (without any additional programming effort) is implement VPD (Virtual Private Database).

The link is here:
http://download-west.oracle.com/docs/cd/B10501_01/appdev.920/a96590/adgsec02.htm#1009919

HTH
GovindanK

On Fri, 14 Nov 2003 09:49:25 -0800, "Hamid Alavi" <hamid.alavi_at_quovadx.com> said:
> List,
>
> I have 50 lookup tables and all of them have effective date & end date
> I want to create a rule or some thing like this which any select
> statement select the data from these lookup where the sysdate between
> effective date & end date. Example:
>
> select * from table1 ( always select those records where sysdate
> between effective date & end date). Any Idea?
>
> Thanks,
>
> Hamid Alavi

> Fat City Network Services -- 858-538-5051 http://www.fatcity.com San
> Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message to:
> ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the
> message BODY, include a line containing: UNSUB ORACLE-L (or the name of
> mailing list you want to be removed from). You may also send the HELP
> command for other information (like subscribing).

-- 
http://www.fastmail.fm - Email service worth paying for. Try it for free
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: GovindanK
  INET: gkatteri_at_fastmail.fm

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).