Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Can I create a "virtual table" with PL/SQL

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

From: Valentin Minzatu <valentinminzatu_at_yahoo.com>
Date: 19 Mar 2007 10:45:28 -0700
Message-ID: <1174326328.881345.294430@l77g2000hsb.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US