Devart Forums

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

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.