Re: More on ORA-01722
From: vsevolod afanassiev <vsevolod.afanassiev_at_gmail.com>
Date: Wed, 20 Mar 2013 14:31:12 -0700 (PDT)
Message-ID: <8607bd35-fb8e-4a15-95c5-dd7cddad8f49_at_googlegroups.com>
I expect Oracle to use datatype conversion on the right side of equal sign:
- It will prevent ORA-01722 error.
Date: Wed, 20 Mar 2013 14:31:12 -0700 (PDT)
Message-ID: <8607bd35-fb8e-4a15-95c5-dd7cddad8f49_at_googlegroups.com>
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.