How do I use NUMBER(n) rather than NUMBERPS(n,n)??

[teresni]

I am using Visio 2003, trying to model an Oracle 9i database.
I have set the database driver to Oracle Server.
I want to define a data type to be something like NUMBER(4).
But whenever I try to do this, Visio automatically changes it
to NUMBERPS(4,0).
How do I get this to stop happening??
I tried defining my own data types, but it still doesn't work
right.
I want the ERD to reflect the actual underlying Oracle data types.

 

[Matt M]

I am using Visio 2003, trying to model an Oracle 9i database.
I have set the database driver to Oracle Server.
I want to define a data type to be something like NUMBER(4).
But whenever I try to do this, Visio automatically changes it
to NUMBERPS(4,0).
How do I get this to stop happening??

Hi

Not to worry. NUMBERPS(4,0) is a synonym for NUMBER(4). If you were to
generate a schema from your model (which unfortunately isn't possible in
Visio 2003), you'd find that NUMBERPS(4,0) becomes NUMBER(4,0).

Matt M.

 

[teresni]

Thanks much for the answer. Although I must say that it doesn't seem
to make much sense to do this.
It would be better to view the ERD and see the actual datatypes that
will be used to create the tables.
That way, someone else could look at the ERD and easily create the SQL
scripts. This requires the
person entering the SQL statements to understand this 'anomaly'.