Menu

#753 Oracle: create table loose decimal

open
5
2012-12-29
2009-04-20
Anonymous
No

In an Oracle 10g, I've created the following table

create table "mytest" (
id number(11) primary key not null,
value NUMBER(9,3),
description varchar2(200)
);

the code created by the function "create table script" is

CREATE TABLE "test"."mytest"
(
ID decimal(11) PRIMARY KEY NOT NULL,
VALUE decimal(9),
DESCRIPTION varchar2(200)
)
;

The information about 3 decimals length part of column value is lost.

Discussion


Log in to post a comment.