Re: Can I create a "virtual table" with PL/SQL

From: Matthias Hoys <anti_at_spam.com>
Date: Mon, 19 Mar 2007 19:47:45 +0100
Message-ID: <45fedad0$0$13862$ba620e4c@news.skynet.be>

"Guy" <guhar1_at_yahoo.com> wrote in message news:1174324698.398447.64550_at_p15g2000hsd.googlegroups.com...
>I have a legacy table which I cannot change, because hundreds of
> modules in my crappy application make direct reference to it in sql
> stmts and pro*c stmts. We have new security rules we would like to
> implement and which will impact on the number of rows return by
> queries on that legacy table. I was thinking of using a trigger for
> that task but there is no SELECT triggering event available. So is
> there a way to control proceduraly, with PL-SQL, the rows returned by
> a table. Some virtual table mecanism ?
>
> Thanks.
>

Rename the old table and create a synonym to a view ? Received on Mon Mar 19 2007 - 13:47:45 CDT