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’;


Oracle Design Tool – SQL Developer Data Modelling

On my most recent project I am again designing another data warehouse solution.

My tool of choice for data modelling has always been CA’s ERwin DataModeler

This is great, but we run into problems when trying to reverse engineer an existing database as this means that either my laptop has to go onto the customers network; that’s never going to happen. or the customer has to buy a copy of ERWin to use on their desktop.
My most recent customer is a dedicated Oracle customer using Database, Data Guard, RAC, Forms, OBIEE, Answers and on and on.

The obvious choice would be Oracle Designer. I have not used this in a few years but the last time it took me two days to get it installed and configured.

A quick search pointed me to an early adopters release of SQL Developer Data Modelling, you can find it here :
Here are a few of my thoughts:

Continue reading Oracle Design Tool – SQL Developer Data Modelling