Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: UPPER in a WHERE gives me a 00936 errror
<mmonn_at_comcast.net> wrote in message
news:1138821435.600191.18090_at_g14g2000cwa.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
>
please post the entire statement and error, preferably from SQL*plus so it has the line and column indicator
also database version
++ mcs Received on Wed Feb 01 2006 - 14:18:48 CST