Skip to Main Content
Forums

SQL Developer Data Modeler

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Integer datatype

Reg BrinkJan 31 2014 — edited Feb 4 2014

Hi,

In my Oracle 11 database, I have an INTEGER datatype. When I try to synchronize that to my database, datamodeler comes back saying the database column is a NUMBER(*,0) and, as such, indicates that the column does not match the model.

Specifically, I have a table COUNTRIES in model that has a column COUNTRY_ID defined as an INTEGER. In the database, it is also an INTEGER. When I synchronize the model, it shows that the columns do not match and the difference is the Data Type (NUMBER(*,0) != INTEGER) and Data Type Kind (Logical Type(NUMERIC) != Logical Type (Integer))

Is there a way to get SQL Datamodeler 4.0 to match the integer datatype to native?

Thanks!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 4 2014
Added on Jan 31 2014
3 comments
1,722 views