Integer datatype shown as number(*,0) in deploymnt script ?

gahuja

In the deployment script we have noticed everywhere where there is integer datatype,it is getting converted as number(*,0), , ofcourse on deployment again the number(*,) gets converted into integer

I would like to know why this conversion is happening and why can't the tool simple generate the script with ineteger datatype

Regards
Gagan

richardjm

Which tool is this in? Can you give an example of the portion of the script in which this is happening.

gahuja

e..g

CREATE TABLE staging.rg_temp_318261722_1 (
cob_date DATE NOT NULL,
run_id NUMBER(*,0) NOT NULL,
processing_location VARCHAR2(3 BYTE) NOT NULL,
trial_balance_id NUMBER(25) NOT NULL,
freq_ind CHAR,
"ADJ_DATE" DATE,
source_ref VARCHAR2(56 BYTE),
native_currency VARCHAR2(3 BYTE),
expiry_date DATE,
key_pos_17 CHAR DEFAULT '_',
key_pos_18 CHAR DEFAULT '_',


CREATE TABLE control.d_trade_bkp (
cob_date DATE NOT NULL,
run_id NUMBER(*,0) NOT NULL,
processing_location VARCHAR2(3 BYTE) NOT NULL,
trial_balance_id NUMBER(25) NOT NULL,
freq_ind CHAR,

IN botht he cases the dataype of run_id is integer which gets converted to NUMBER(*,0)

Need to know why tool is doing this

richardjm

The integer and number are synonymous it's just the way we output the datatype as we have no concept of how the number type was created from as it could be either syntax - Oracle doesn't record this in the system views.