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

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Mon, 19 Mar 2007 18:24:10 +0100
Message-ID: <45fec739$0$32309$426a34cc@news.free.fr>

"Guy" <guhar1_at_yahoo.com> a écrit dans le message de 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.
|

View?

Regards
Michel Cadot Received on Mon Mar 19 2007 - 12:24:10 CDT