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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
