CREATE TABLE "AWB_SPLIT"
(
AWB_SEQ decimal(9) NOT NULL,
SPLIT_ID decimal(2) NOT NULL,
RATE decimal(10),
CONTOUR char(3),
CNOS_REMARKS varchar2(426),
THRU_TRANSIT char(1),
PRIORITY char(1),
CURRENCY char(3),
REMARKS varchar2(2048),
PIECES decimal(5),
WEIGHT decimal(7),
VOLUME decimal(9),
ULD_COUNT decimal(7),
TRN decimal(2),
MI_CURRENCY char(3),
MI_RATE decimal(10),
BASE_CURRENCY char(3),
BASE_RATE decimal(10),
BOOK_WEIGHT decimal(7),
BOOK_VOLUME decimal(9),
ALI_REMARKS varchar2(2048),
CONSTRAINT PK_AWB_SPLIT PRIMARY KEY (AWB_SEQ,SPLIT_ID)
)
;
The above SQL is missing the decimal precision in weight, volume, and rate fields.
I can confirm this bug on Snapshot-20110822_1814. Columns of type DECIMAL(X, Y) are being output as DECIMAL(X) in the create table script. Database is Oracle 11g using the Oracle Thin Driver with the latest ojdbc6.jar driver.