Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Views With Parameters or some such solution???
Only by creating a table and putting the parameters in it (by doing this you
can also make the same view return a different subset of records for
different users)
i.e. have a table VIEW_PARAMS with columns USERNAME, LOWERLIMIT, UPPERLIMIT
and a view along the lines of
SELECT SOMETHING FROM SOME TABLE WHERE SOMEVALUE BETWEEN VIEW_PARAMS.LOWERLIMIT AND VIEW_PARAMS.UPPERLIMIT AND USER = VIEW_PARAMS.USERNAME Dave Waterworth
jairamk_at_geocities.com wrote in message <7ldhno$jc3$1_at_nnrp1.deja.com>...
>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.
Received on Sat Jul 03 1999 - 08:35:00 CDT
![]() |
![]() |