-
Question about datatypes
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?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|