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