Re: Operator and condition precedence
From: Michael Moore <michaeljmoore_at_gmail.com>
Date: Tue, 8 Sep 2009 22:19:20 -0700
Message-ID: <26fdee6e0909082219r3dc6efb0lfaf5a4db0f3a3fdb_at_mail.gmail.com>
Ric,
On my system
Date: Tue, 8 Sep 2009 22:19:20 -0700
Message-ID: <26fdee6e0909082219r3dc6efb0lfaf5a4db0f3a3fdb_at_mail.gmail.com>
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-lReceived on Wed Sep 09 2009 - 00:19:20 CDT