Integer type

halley73to · Post by **halley73to** » Tue 20 Oct 2009 10:24

Hi,
how can i define a column of a table of number type (38,0).

If i leave default option the OeaDeveloperTools generate a column of NUMBER type without precision and scale.

Thanks, Luca

.jp · Post by **.jp** » Tue 20 Oct 2009 14:21

Hello Luca,

Yes, this is a bug. The development team is notified about this problem.
You can set precision and scale properties of a column manualy by using this script:

ALTER TABLE SchemaName.TableName
MODIFY (COLUMNNAME NUMBER(38, 0));

Replace SchemaName.TableName with the names of your schema and table and COLUMNNAME with the name of the column where you would like to change the precision and scale properties.

We will fix this bug in the next build of OraDeveloper Studio.

Best regards.