Re: Operator and condition precedence
- From: Martin Berger <martin.a.berger@xxxxxxxxx>
- To: michaeljmoore@xxxxxxxxx
- Date: Wed, 9 Sep 2009 20:33:38 +0200
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
Other related posts:
