Home -> Usenet -> comp.databases.oracle -> Re: Selecting against values outside the ASCII range!!!

Re: Selecting against values outside the ASCII range!!!

From: Jan <janik_at_pobox.sk>
Date: 6 Apr 2004 08:05:29 -0700
Message-ID: <81511301.0404060705.7d0d06fe_at_posting.google.com> 







Since "col3" is a Char datatype then



 In this case:


select * from table1 when col3 = 1



1 is a number so an implicit conversion is done. Values in "col3" are
tried to be converted into a number type. If there in col3 is at least
one non-number value, it raises that error.



You can fix it by 



select * from table1 when col3 = '1'





Jan
Received on Tue Apr 06 2004 - 17:05:29 CEST












Original text of this message