RE: Force implicit data conversion - REOPENED

Got my confusion – I was reading the following quote from the same doc incorrectly:

“During SELECT FROM operations, Oracle converts the data from the column to the type of the target variable.”

It is NOT applicable to bind variables in the same SELECT FROM.

Sometimes it is useful to really READ the doc ☺

Thanks,
Michael

From: Sayan Malakshinov [mailto:xt.and.r_at_gmail.com] Sent: Monday, March 23, 2015 4:21 PM
To: Michael Rosenblum
Cc: Oracle-L Freelists
Subject: Re: Force implicit data conversion - REOPENED

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')

--
http://www.freelists.org/webpage/oracle-l