Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: parameterized view
sorry -- message sent by mistake, see comments in my other post
"mcstock" <mcstockx_at_xenquery.com> wrote in message
news:ZMSdnegsW5m1oTuiRVn-iw_at_comcast.com...
> not really needed
> "Steven" <SPAMBLOCKERsteven.pannell_at_gmx.net> wrote in message
> news:bo5dee$13tr0d$1_at_ID-82797.news.uni-berlin.de...
> > Hi,
> >
> > I'm wondering if it is possible to create some kind of parameterized
view
> in
> > oracle. Like:
> >
> > create view myview as
> > select * from customer_table where cust_id = ?
> >
> > Then in my query I call
> >
> > select * from myview where :cust_id = 1234
> >
> > Probably not huh?
> >
> > what I'm looking for is a way to store SQL Queries in the database that
I
> > can change dynamically and not hardcode in the application.
parameterized
> > views would be great!
> >
> > Any ideas?
> >
> > Thanks,
> > Steve,
> >
> >
> > --
> > -----------------------------------------------------------------
> > Holidays in Berchtesgaden, Germany:
> > http://www.sonnenkoepfl.de
> > http://unterkunft-berchtesgaden.de
> > http://pension-berchtesgaden.de
> >
> >
>
>
Received on Mon Nov 03 2003 - 06:09:34 CST