Tag: 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
Protected: Oracle Design Tool – SQL Developer Data Modelling
by Ross (Admin) on Nov.30, 2008, under Dimensional Modelling, MIG, Maxima, Maxima Information Group
Recent Photos
Google Reader- KeePass 2.13 released -- now with monospaced passwords!
- Cock-touching forbidden in Kyoto
- Happy Shopper
- September 5, 2010
- Green Tomato Recipe Call Out
- Workload Management for Operational Data Warehousing
- How To Master GIMP, For Graphics, Quickly And Easily
- The crap we put up with getting on and off an airplane
- Productive Magazine #5 available! Miguel Guía interview about art, passion, habits and more!
- Five top fives in Business Intelligence
