Oracle-L: RE: Create Rule

From: Mercadante, Thomas F <NDATFM_at_labor.state.ny.us>
Date: Fri, 14 Nov 2003 12:24:26 -0800
Message-ID: <F001.005D6B1D.20031114122426@fatcity.com>

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: Hamid Alavi
INET: hamid.alavi_at_quovadx.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).

This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.

**********4
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Jamadagni, Rajendra
INET: Rajendra.Jamadagni_at_espn.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------