Does anyone know the meaning of "-~" in a oracle table. The column is dfined as Number and must not be null. The column is populated from another table (Through an informatica mapping) where the value is NULL?
Printable View
Does anyone know the meaning of "-~" in a oracle table. The column is dfined as Number and must not be null. The column is populated from another table (Through an informatica mapping) where the value is NULL?
It could be informatica inserting -~ characters, if it is inserted as null it should not contain anything in Oracle. Oracle would not insert into a number column. How are you checking the value in the column, SQLPlus or other tool?
Thanx for the input, but discovered an expression in the informatica mapping that assigned -9.9999E125 to this field, if
the input field was NULL (which it was) and Oracles reprsentation of this number (basically Negative infinity) is -~.