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

Home -> Community -> Usenet -> c.d.o.tools -> Re: SQL parameter with join?

Re: SQL parameter with join?

From: Bart <Bart_at_opcomp.demon.co.uk>
Date: Wed, 11 Apr 2001 18:17:35 +0100
Message-ID: <987009833.2473.0.nnrp-12.9e985e86@news.demon.co.uk>

You need to quote your parameter and use appropriate wildcarding, but it should work. Look at indexing of a.f1 and b.f1 for performance. "gg200492" <gg200492_at_ratp.fr> wrote in message news:3AD477EC.B240F21E_at_ratp.fr...
>
> Can I have a parameter in the where clause when i have already a join on
> this field?
> how to do else?it doesn't work quickly
>
> ex:
>
> select a.f1,b.f2
> from a,b
> where a.f1=b.f1
> and a.f1 like &parameter1;
>
Received on Wed Apr 11 2001 - 12:17:35 CDT

Original text of this message

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