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 ViewsI was wondering if it is possible to parameterizes a view. did some googling but did not find any satisfactory results.