Re: Operator and condition precedence

From: Martin Berger <martin.a.berger_at_gmail.com>
Date: Wed, 9 Sep 2009 20:33:38 +0200
Message-Id: <35B30104-23D2-42B9-9CC1-C535BB0CCA59_at_gmail.com>

Mike,

does not play it too easy:

select * from dual where 'xyz'>'' and to_number('abc') > 0

                                                 *

ERROR at line 1:
ORA-01722: invalid number

SQL> select * from dual where dummy > '' and to_number(dummy) > 0;

no rows selected

(10.2.0.4 on Sunos10 - 2nodeRAC)

seems to be something for deeper investigating ;-)

Martin

Am 09.09.2009 um 07:19 schrieb Michael Moore:

> Ric,
> On my system
>
>
> select * from dual
> where 'xyz'>'' and to_number('abc') > 0;
>
> throws a numeric error
>
>
> Mike
>
>
>
>

--
http://www.freelists.org/webpage/oracle-l




application/pkcs7-signature attachment: smime.p7s

Received on Wed Sep 09 2009 - 13:33:38 CDT