Integer type

Discussion of open issues, suggestions and bugs regarding database management and development tools for Oracle
Post Reply
halley73to
Posts: 29
Joined: Wed 07 Oct 2009 07:24

Integer type

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
Devart Team
Posts: 306
Joined: Wed 09 Sep 2009 06:55
Location: devart

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.

Post Reply