Categories
Oracle Work

Oracle Datatype Conversions

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

Categories
Gardening Home Improvements

The Great Gardening Project

DSCN0399

Whilst nowhere near as ambitious as J.D. and Kris’ project here I have decided to do some work in the garden this year. I’m a few weeks behind writing up my progress so I’ll try and summarise after the break.

Categories
Oracle Windows Work

Tell Me When The DB Is Back

database 2
Creative Commons License photo credit: Tim Morgan
Today at work the development DB went down.
My days of fixing databases are long gone, but the guys that are are not so good at letting everyone know that the database is back up.
I created this windows batch script to let me know.