RE: Create Rule

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:tlaporte_at_anim.dreamworks.com>

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: tlaporte_at_anim.dreamworks.com

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).