Re: Question about (+) in WHERE clause

christos_tsoukalas_at_yahoo.com (Chris) wrote in message news:<1d9407f8.0111120852.5a10caa1_at_posting.google.com>...

Hi Chris

You have to put the + sign on the side that you don't need existing row, the problem in your query
is that the LIKE 'j%' cancel the use of the outer join,

i think you can't use outer join on LIKE operator

an example of query working with operator and outer join may look like this

    SELECT E.FIRST_NAME, A.STATE

    FROM      EMPLOYEES E, ADDRESS A
    WHERE     E.LAST_NAME(+) = 'j'
    AND       E.ADDRESS_ID (+) =A.ADDRESS_ID

hth
Chris
> Hi Mike,
>
> But does the position of (+) make any difference in the query?
>
> That is, how the query:
>
> SELECT E.FIRST_NAME, A.STATE
> FROM EMPLOYEES E, ADDRESS A
> WHERE E.LAST_NAME LIKE 'j%'
> AND E.ADDRESS_ID (+) =A.ADDRESS_ID
>
> differs from the query:
>
> SELECT E.FIRST_NAME, A.STATE
> FROM EMPLOYEES E, ADDRESS A
> WHERE E.LAST_NAME LIKE 'j%'
> AND E.ADDRESS_ID =A.ADDRESS_ID (+)
>
> Thanks,
>
> Chris
>
>
>
>
>
> "Mike Moore" <hicamel_at_mail.home.com> wrote in message news:<Am0H7.13774$Vf4.7439559_at_news1.rdc1.sfba.home.com>...
> > This is called an "outer join".
> > Now that you know what it is called, you should have no problem
> > looking it up even by searching on google.
> > Mike
> >
> >
> > Chris <christos_tsoukalas_at_yahoo.com> wrote in message
> > news:1d9407f8.0111091143.5e07d76e_at_posting.google.com...
> > > Hi,
> > >
> > > I try to debug a SQL statement of the form:
> > >
> > > SELECT E.FIRST_NAME, A.STATE
> > > FROM EMPLOYEES E, ADDRESS A
> > > WHERE E.LAST_NAME LIKE 'j%'
> > > AND E.ADDRESS_ID (+) =A.ADDRESS_ID
> > >
> > >
> > > I am not really sure what this (+) stands for. Do you know any Oracle
> > > documentation explaining the use of this symbol?
> > >
> > > Thanks,
> > > Chris
Received on Wed Nov 14 2001 - 01:05:22 CET