parameterized view

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