RE: Operator and condition precedence

From: Ric Van Dyke <ric.van.dyke_at_hotsos.com>
Date: Wed, 9 Sep 2009 08:17:08 -0500
Message-ID: <C970F08BBE1E164AA8063E01502A71CF0154F69C_at_WIN02.hotsos.com>



Right you are:  

SQL> select * from dual

  2 where 'xyz'='' and to_number('abc') > 0;

where 'xyz'='' and to_number('abc') > 0

                             *

ERROR at line 2:

ORA-01722: invalid number  

SQL> SQL> SQL> explain plan for

  2 select * from dual

  3 where 'xyz'='' and to_number('abc') > 0;

SQL> select * from table(dbms_xplan.display);  

PLAN_TABLE_OUTPUT






Plan hash value: 3752461848  



---

| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |



---

| 0 | SELECT STATEMENT | | 1 | 2 | 2 (0)| 00:00:01 |

|* 1 | FILTER | | | | | |

| 2 | TABLE ACCESS FULL| DUAL | 1 | 2 | 2 (0)| 00:00:01 |



---
 

Predicate Information (identified by operation id):


 

   1 - filter(TO_NUMBER('abc')>0 AND 'xyz'='')  


Ric Van Dyke

Hotsos Enterprises


 

Hotsos Symposium

March 7 - 11, 2010

Be there.    


From: Michael Moore [mailto:michaeljmoore_at_gmail.com] Sent: Tuesday, September 08, 2009 10:19 PM To: Ric Van Dyke
Cc: rjoralist_at_society.servebeer.com; Oracle L Subject: Re: Operator and condition precedence  

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
Received on Wed Sep 09 2009 - 08:17:08 CDT

Original text of this message