APEX

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!

DDL generation produces NUMBER(*,0) instead of INTEGER?

AndyHApr 22 2013 — edited Apr 22 2013

Hi,

Running APEX 4.1.1.00.23 on Oracle 11g database.

I have fields that were defined in the original DDL as integers. When I use a tool such as PL/SQL Developer to look at the table, it shows the datatype as 'INTEGER'.

When I use APEX to generate DDL, these fields are shown as NUMBER(*,0). I can see how a scale of 0 represents an integer, but what does a precision of '*' mean?

NUMBER(*,0) is accepted by Oracle 10g and 11g databases, but not but by some tools that import DDL - e.g. Oracle SQL Developer Data Modeler.

Is NUMBER(*,0) valid in DDL - I don't see this format in the Oracle doc's, but

And if it is, is there any way of configuring the DDL output to show 'INTEGER' as 'INTEGER'?

Locked Post

New comments cannot be posted to this locked post.

Locked on May 20 2013

Added on Apr 22 2013

#apex-discussions

1 comment

339 views