Giot some developers here using Sybase's Power Designer to model their DB. (I have little input by the way folks).

They have a multitude of datatypes in their model, and for the life of me I can't see why you would use them in an Oracle DB. Well, perhaps I should say I can't see why you would implemenet this model directly into an Oracle table.

There are data domains mapped to proposed datatypes like:

Domain Datatype
-------- -----------
CURRENCY NUMBER(9,2)
LCURRENCY NUMBER(12,2)(A bigger currency amount!)
QTY NUMBER(11,3)
LQTY NUMBER(14,3) (A much bigger qty!)
CODE VARCHAR2(10)
SCODE VARCHAR2(2) (A small code!)

For the life of me I can't see why - other than to enforce some business rule at the table definition level - why you'd implement domains like this.

Any comments - opinions?