Hi,
We have a table with the following structure:
LOC_LOC VARCHAR2(9)
LOC_REFNO NUMBER(6)
LOC_DEDICATED VARCHAR2(1)
LOC_FLG_2 VARCHAR2(1)
LOC_FLG_3 VARCHAR2(1)
LOC_FLG_4 VARCHAR2(1)
LOC_FLG_5 VARCHAR2(1)
LOC_FLG_6 VARCHAR2(1)
LOC_FLG_7 VARCHAR2(1)
LOC_FLG_8 VARCHAR2(1)
LOC_BIN_SIZE_CAT VARCHAR2(1)
LOC_BIN_SIZE_CD NUMBER(3)
LOC_BIN_SIZE_SFX VARCHAR2(1)
LOC_WRHS NUMBER(1)
LOC_ACCESS_1 NUMBER(1)
LOC_ACCESS_2 NUMBER(1)
LOC_ACCESS_3 NUMBER(1)
LOC_RELATIVITY NUMBER(1)
LOC_NOMINATION NUMBER(1)
LOC_ALLOC NUMBER(1)
LOC_PALLETS NUMBER(2)
LOC_QTY NUMBER(7)
LOC_MAX_QTY NUMBER(7)
LOC_MNT_YMD DATE
LOC_CYC_CT_YMD DATE
LOC_REFILL_CT NUMBER(3)
LOC_CREATED_TIMESTAMP DATE
LOC_LAST_UPDATED_TIMESTAMP DATE
After loading data into this table using a script I found the following:
1* select LOC_MAX_QTY,loc_loc from naloc_err where loc_refno = 78053
SQL> /
LOC_MAX_QTY LOC_LOC
----------- ---------
6.0000E+34 FZ1702L3
The column LOC_MAX_QTY is declared with number(7). I am wondering how Oracle inserted a value like this.
Please clarify.
Thanks
