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
Recent Photos
Google Reader- Comic for September 1, 2010
- Beyond Texting
- Are you spending quality family time plus work productively? Find out via the #SAP Business Objects -Work/Life Dashboard: http://ow.ly/2x2N2
- Poor Juxtaposition
- OpenHeatMap Turns Your Data into a Custom Heat Map [Maps]
- Getting Wiser
- 8 Free BlackBerry Games Worth Downloading
- August 29, 2010
- Quiz Night.
- Reality FAIL
