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- Top 10 'Sesame Street' controversies - THE WEEK
- A Guide to Creating Dashboards People Love to Use
- Google Latitude Now Tracks Location History, Alerts You to Nearby Friends
- WiFi Body Scale Auto-Tweets Each Time You Step On It
- Nice Try
- Drunk Woman Falls Onto Subway Tracks and Survives Near Miss [Video]
- Oracle BI EE 10.1.3.4.1 – Single Table Repository Design – Part 1
- BI / MI Project Manager
- Twitter and Text Analysis to Help You Surf Through Traffic
- Four Tips for a Successful Data Migration Project
