Re: More on ORA-01722

From: vsevolod afanassiev <>
Date: Wed, 20 Mar 2013 14:31:12 -0700 (PDT)
Message-ID: <>

I expect Oracle to use datatype conversion on the right side of equal sign:
- It will prevent ORA-01722 error.
  • If will ensure that if this column is indexed the index is used I don't think it requires artificial intelligence. Oracle has to use datatype conversion somewhere, either on the left or on the right. I don't see any advantages of using it on the left. Another option is to establish some ranking: a number can always be converted into a string but the opposite isn't true. So when comparing number to a string Oracle should convert this number into string instead of trying to convert string into number.
Received on Wed Mar 20 2013 - 22:31:12 CET

Original text of this message