Re: Parameterized Views

There are two ways

1. Using package variables
2. Using application context

1. create view abc as select * from aaa where id = var_pkg.x

Before accessing the view you will have to initialize the package variable with a value

2.
create view abc as select * from aaa where id = sys_context('app_ctx','var1');

Before accessing the view you will have to initialize the application context

amit



Mir M. Mirhashimali wrote:
I was wondering if it is possible to parameterizes a view. did some googling but did not find any satisfactory results.



--
http://www.freelists.org/webpage/oracle-l


Other related posts: