Content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: 8bit
Subject: RE: Parameterized Views
Date: Wed, 19 Sep 2007 13:19:00 -0500
Message-ID: <302F06193D7F4D48ABC997408E786BD002759466@MSPM1BMSGM09.ent.core.medtronic.com>
In-Reply-To: <46F15E5C.3020401@rice.edu>
Thread-Topic: Parameterized Views
References: <607D6181D9919041BE792D70EF2AEC48242F1C@LIMENS.sivsa.int> <46F15E5C.3020401@rice.edu>
From: "Elliott, Patrick" <patrick.elliott@medtronic.com>
To: <mhyder@rice.edu>, "Alvaro Jose Fernandez" <alvaro.fernandez@sivsa.com>
Cc: <oracle-l@freelists.org>
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
Precedence: normal
Reply-to: patrick.elliott@medtronic.com


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@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Mir M. Mirhashimali
Sent: Wednesday, September 19, 2007 12:38 PM
To: Alvaro Jose Fernandez
Cc: oracle-l@freelists.org
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@freelists.org [mailto:oracle-l-bounce@freelists.org] En nombre de Mir M. Mirhashimali
> Enviado el: miércoles, 19 de septiembre de 2007 18:47
> Para: oracle-l@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


___________________________________________________________________________________________________
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
--
http://www.freelists.org/webpage/oracle-l