If you write your app to use bind variables then this would seem to
accompish what you want in your example.
--
Niall Litchfield
Oracle DBA
Audit Commission Uk
"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 - 05:43:23 CST
