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" <[EMAIL PROTECTED]> 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: > [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
