Re: Parameterized Views

  • From: "Mir M. Mirhashimali" <mhyder@xxxxxxxx>
  • To: Alvaro Jose Fernandez <alvaro.fernandez@xxxxxxxxx>
  • Date: Wed, 19 Sep 2007 12:37:32 -0500

Hi Alvaro,

I mean i have a SQL statement something like this

select delegate_userid, orgid
 from table1
where loginid = 'SOMEUSER'
union
select delegate_userid, orgid
 from table2
where loginid = 'SOMEUSER'
union
select delegate_userid, orgid
 from table3
where loginid = 'SOMEUSER'

I want to create the above sql as a view and want to pass the 'SOMEUSER' as a parameter to the view.

Thanks

--
Mir M. Mirhashimali
Oracle Systems Manager
Database Architecture, Enterprise Applications
Rice University
(713) 348 6365



Alvaro Jose Fernandez wrote:
Hello Mir,

I don't understand exactly the meaning of a parametrized view. Could you 
elaborate more on this?

regards
alvaro

-----Mensaje original-----
De: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] En 
nombre de Mir M. Mirhashimali
Enviado el: miércoles, 19 de septiembre de 2007 18:47
Para: oracle-l@xxxxxxxxxxxxx
Asunto: Parameterized Views

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: