Integer type

Integer type

Postby 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
halley73to
 
Posts: 29
Joined: Wed 07 Oct 2009 07:24

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


Return to dbForge for Oracle