The "Scripts" tab generates wrong DDL for number columns with 0 precision. (4304628)

User runs the following in the Editor:

CREATE TABLE ddl_test
(
integer_number NUMBER (38,0)
)
TABLESPACE users;


Then they go into the Schema Browser, click on the table, and then click on the scripts tab and shows the following:

CREATE TABLE YYUAN.DDL_TEST
(
INTEGER_NUMBER NUMBER(38)
)
TABLESPACE USERS

The precession for number(38,0) is not there.

The precision (38) is there. It's the SCALE that's not. They are the same to Oracle. A NUMBER(38) is the same as an integer, which has no scale. To test this do this:

CREATE TABLE INT_TEST ( COL1 INTEGER );

Then run it and do a DESC INT_TEST; and run in SQL*Plus. It will be a NUMBER(38). This is just how Oracle reports the number and Toad reports what Oracle says.