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: UPPER in a WHERE gives me a 00936 errror

Re: UPPER in a WHERE gives me a 00936 errror

From: Terry Dykstra <tddykstra_at_forestoil.ca>
Date: Wed, 01 Feb 2006 17:25:49 GMT
Message-ID: <xa6Ef.239175$OU5.5521@clgrps13>

<mmonn_at_comcast.net> wrote in message
news:1138814539.569974.5520_at_g44g2000cwa.googlegroups.com...
> This one works...
>
> FROM From.Timelog, From.Cmo_Worker WHERE ( Timelog.Case_Manager (+)=
> Cmo_Worker.Portalid )
>
> but I needed the opposite joins..so I did...
>
> FROM From.Timelog, From.Cmo_Worker WHERE ( UPPER(Timelog.Case_Manager)
> (+)= Cmo_Worker.Portalid )
>
> This one errored out with a missing expression
>

Try:

FROM From.Timelog, From.Cmo_Worker WHERE ( UPPER(Timelog.Case_Manager(+)) = Cmo_Worker.Portalid )

-- 
Terry Dykstra
Canadian Forest Oil Ltd.
Received on Wed Feb 01 2006 - 11:25:49 CST

Original text of this message

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