Re: Parameterized Views
- From: amit poddar <amit.poddar@xxxxxxxx>
- To: mhyder@xxxxxxxx
- Date: Wed, 19 Sep 2007 14:15:31 -0400
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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
