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.



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


Other related posts: