Ross Goodman

Oracle

Oracle Datatype Conversions

by Ross (Admin) on Apr.15, 2009, under Oracle, Work

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

Leave a Comment :, , , more...

Protected: Tell Me When The DB Is Back

by Ross (Admin) on Apr.07, 2009, under Oracle, Windows, Work

This post is password protected. To view it please enter your password below:


Enter your password to view comments :, , , more...