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: William Robertson <william.robertson_at_bigfoot.com>
Date: 2 Feb 2006 07:03:41 -0800
Message-ID: <1138892620.986601.276890@g14g2000cwa.googlegroups.com>


mmonn_at_comcast.net wrote:
> FROM From.Timelog, From.Cmo_Worker WHERE ( UPPER(Timelog.Case_Manager)
> (+)= Cmo_Worker.Portalid )
>
> This one errored out with a missing expression

The outer join (+) operator needs to be placed immediately after the column.

btw you have a user account named "FROM"? Received on Thu Feb 02 2006 - 09:03:41 CST

Original text of this message

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