Re: Force implicit data conversion - REOPENED
- From: Sayan Malakshinov <xt.and.r@xxxxxxxxx>
- To: Michael Rosenblum <mrosenblum@xxxxxxxxxxx>
- Date: Mon, 23 Mar 2015 23:20:37 +0300
Quote from this link:
>> The following rules govern implicit data type conversions:
>> When comparing a character value with a numeric value, Oracle converts
the character data to a numeric value.
In both your cases there are implicite conversion from character value to
number:
1. object_name --> to_number(object_name)
2. '100' --> to_number('100')
Other related posts: