Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> UPPER in a WHERE gives me a 00936 errror
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