Re: Views With Parameters or some such solution???

A copy of this was sent to jairamk_at_geocities.com (if that email address didn't require changing) On Wed, 30 Jun 1999 16:47:56 GMT, you wrote:

>Hi! All!
>
> i am working on an application which requires the creation of a view
>joining 3 large tables (outer join). These three tables are growing
>daily... so i am afraid that if i use this view it will result in
>cartesian products being performed for all records... i would like to
>try and limit this by being able to pass a key value as a parameter
>to the view query... is it possible? if not is there any other way i can
>try and get around this problem... i am using Oracle 8.0.4 on Solaris
>
>thanks in advance
>regards
>jairam kuppuswamy
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.

It sounds like you are trying to push the predicates down into the view instead of applying the predicates to the view after the fact. If so, see:

http://www.deja.com/[ST_rn=ps]/getdoc.xp?AN=387141448&fmt=text

that shows how to do this in Oracle8.0 and less. In Oracle8i, release 8.1, you can use application contexts to achieve the same exact effect.. If you want to read about them see http://govt.us.oracle.com/~tkyte/ and the article on dbms_rls.

--
See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Wed Jun 30 1999 - 12:15:28 CDT