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

UPPER in a WHERE gives me a 00936 errror

From: <mmonn_at_comcast.net>
Date: 1 Feb 2006 09:22:19 -0800
Message-ID: <1138814539.569974.5520@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 Received on Wed Feb 01 2006 - 11:22:19 CST

Original text of this message

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