Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Views With Parameters or some such solution???

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

From: Dave Waterworth <pscdaw_at_ihug.com.au>
Date: Sat, 3 Jul 1999 23:35:00 +1000
Message-ID: <7ll3el$ffu$1@toto.tig.com.au>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US