Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Can I create a "virtual table" with PL/SQL
On Mar 19, 1:24 pm, "Michel Cadot" <micadot{at}altern{dot}org> wrote:
> "Guy" <guh..._at_yahoo.com> a écrit dans le message de news: 1174324698.398447.64..._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
VPD? Received on Mon Mar 19 2007 - 12:45:28 CDT
![]() |
![]() |