RE: Parameterized Views
- From: "Elliott, Patrick" <patrick.elliott@xxxxxxxxxxxxx>
- To: <mhyder@xxxxxxxx>, "Alvaro Jose Fernandez" <alvaro.fernandez@xxxxxxxxx>
- Date: Wed, 19 Sep 2007 13:19:00 -0500
What you want is a function that returns a refcursor. You will need to look in
the PL/SQL documentation or check out asktom to see how this is done.
Pat
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Mir M. Mirhashimali
Sent: Wednesday, September 19, 2007 12:38 PM
To: Alvaro Jose Fernandez
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: Parameterized Views
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
___________________________________________________________________________________________________
CONFIDENTIALITY AND PRIVACY NOTICE
Information transmitted by this email is proprietary to Medtronic and is
intended for use only by the individual or entity to which it is addressed, and
may contain information that is private, privileged, confidential or exempt
from disclosure under applicable law. If you are not the intended recipient or
it appears that this mail has been forwarded to you without proper authority,
you are notified that any use or dissemination of this information in any
manner is strictly prohibited. In such cases, please delete this mail from your
records.
To view this notice in other languages you can either select the following link
or manually copy and paste the link into the address bar of a web browser:
http://emaildisclaimer.medtronic.com
--
//www.freelists.org/webpage/oracle-l
Other related posts:
