Hamid, In that case, I think the suggestion made earlier to use the Virtual Private Database functionality is the best solution.
http://download-west.oracle.com/docs/cd/B10501_01/appdev.920/a96590/adgsec02.htm#1009919 -- Tom Thomas A. La Porte, DreamWorks SKG <mailto:[EMAIL PROTECTED]> On Fri, 14 Nov 2003, Hamid Alavi wrote: >So in this case I have to Create 50 Views, I am looking for some sort of >common rule the apply it for all of these 50 tables. > > >-----Original Message----- >Sent: Friday, November 14, 2003 12:24 PM >To: Multiple recipients of list ORACLE-L > > >Hamid, > >Create a view on top of the table and apply the where clause in the view. >Only give the view to the application folks - not the base table itself. > >create or replace view my_view as >select * from some_table >where sysdate between effective date & end date; > >How about that?? > >Tom Mercadante >Oracle Certified Professional > > >-----Original Message----- >Sent: Friday, November 14, 2003 3:14 PM >To: Multiple recipients of list ORACLE-L > > >NO I mean these tables always filtered even if some body run a query like >this: >select * from table1 ------ >> return the all the records where the >sysdate between effective date & end date > >-----Original Message----- >Sent: Friday, November 14, 2003 9:59 AM >To: Multiple recipients of list ORACLE-L > > >you answered your own question ... > >select * >from my_table >where trunc(sysdate) between trunc(eff_date) and trunc(end_date) >/ > >Raj >---------------------------------------------------------------------------- >---- >Rajendra dot Jamadagni at nospamespn dot com >All Views expressed in this email are strictly personal. >QOTD: Any clod can have facts, having an opinion is an art ! > > >-----Original Message----- >Sent: Friday, November 14, 2003 12:49 PM >To: Multiple recipients of list ORACLE-L > > >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 > >Office : 818-737-0526 >Cell phone : 818-416-5095 > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thomas A. La Porte 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).
