Re: Ignore Case

"Mark D Powell" <Mark.Powell_at_eds.com> schrieb im Newsbeitrag news:2687bb95.0302260622.201d08cf_at_posting.google.com... (snipped OP)
>
> Mike, I suspect you are getting a syntax error but since you do not
> provide any basic information on what version of Oracle you are using,
> what tool you are using, or post the actual query results here is my
> WAG:
>
> ver 8.1.7.4 from sqlplus
> UT1> select *
> 2 from marktest
> 3 where upper(mpowel01.marktest.fld4) like upper('two')
> 4 /
> where upper(mpowel01.marktest.fld4) like upper('two')
> *
> ERROR at line 3:
> ORA-00904: invalid column name
>
>
> UT1> c /mpowel01.//
> 3* where upper(marktest.fld4) like upper('two')
> UT1> /
>
> no rows selected
>
> Remove the owner from the where clause as this is not legal Oracle
> syntax though it might be legal for some tool sets, but without more
> information I do not see how anyone is going to be able to help.
>
> HTH -- Mark D Powell --

Hi Mark,

sorry, I can't comfirm that. In my 8.1.7.0 with SQL*PLUS:

08:02:48 po92>select count(*)
08:03:09   2  from iaw.t_wache_umlauf_h
08:03:24   3  where upper(iaw.t_wache_umlauf_h.stamm_gattung_tx) like

 COUNT(*)

     9536

 real: 18167
08:04:41 po92>

I tried this as user 'iaw' (owner of the table) and as another one. I'd thank you if you could shine some light on this case.

Greetings,
Guido Received on Thu Feb 27 2003 - 08:10:32 CET