Oracle Datatype Conversions

Apr 152009

Last week I gave a colleague a demonstration on why, if you have numbers stored in a character string you should convert them explicitly to numbers:

select ‘Yes’
from dual
where ’1000′ between ’000′ and ’999′;

‘YES’
—–
Yes

Ross Goodman