Re: Parameterized Views

From: Mir M. Mirhashimali <mhyder_at_rice.edu>
Date: Wed, 19 Sep 2007 12:37:32 -0500
Message-ID: <46F15E5C.3020401@rice.edu>

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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] En nombre de Mir M. Mirhashimali

> Enviado el: miércoles, 19 de septiembre de 2007 18:47

> Para: oracle-l_at_freelists.org

> 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

Received on Wed Sep 19 2007 - 12:37:32 CDT