Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: parameterized views
"Jim Kennedy" <kennedy-downwithspammersfamily_at_attbi.net> wrote in message
news:oJ5Sc.238851$IQ4.222446_at_attbi_s02...
>
> "Ernest Morariu" <ernest_at_gesora.com> wrote in message
> news:cfan02$eom$1_at_carabinieri.cs.interbusiness.it...
> > Mark,
> >
> > thank you for your answer !
> >
> > The solution you suggested suposes two steps : one to set the value of
the
> > parameter and another one to open the view.
> > I think there is the risk that an user extracts data using the value of
> the
> > parameter set by another user(I mean not the one he/she sets ).
> > What do you think about ?
> >
> > ernest
> >
> >
> > "Mark C. Stock" <mcstockX_at_Xenquery .com> wrote in message
> > news:b9udnSI6eIxDSIXcRVn-qw_at_comcast.com...
> > >
> > > "Ernest Morariu" <ernest_at_gesora.com> wrote in message
> > > news:cfaj7g$71r$1_at_fata.cs.interbusiness.it...
> > > | Hi !
> > > |
> > > | Is it possible in Oracle to create a parameterized view ?
> > > |
> > > | ernest
> > > |
> > > |
> > >
> > > yes, by referencing a package variable (or function) in the where
> clause,
> > > and setting the package variable (or populating appropriate rows in
> > control
> > > tables) prior to SELECTing from the view
> > >
> > > ++ mcs
> > >
> > >
> >
> >
> Nope. Each session is separate from each other. One does not effect the
> other.
> Jim
Right.
Thanks,
Ernest
Received on Tue Aug 10 2004 - 11:01:05 CDT