You can have in a where clause a varchar2 column compared to a number column , if the varchar2 column only contains numeric then it will work.
Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 7470 and (514) 925-7187 [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> -----Original Message----- Boivin, Patrice J Sent: Tuesday, September 09, 2003 4:49 PM To: Multiple recipients of list ORACLE-L I don't know what to think re. this. There is a view here that produces an error, I identified why -- in one AND clause a number(9) datatype column is being joined with a varchar2(50) datatype column. The developer of this code says that this used to run, there must be something wrong with the server. I want to verify... Is there any kind of overloading invoked automatically when Oracle compares columns of different datatypes? i.e. if the varchar2(50) column only contains numbers, would Oracle convert it automatically to number before making the comparison? (My intuition says: NO. ) Patrice. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Paquette INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
