-
not null number field
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?
-
NOT NULL Number field
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 -~.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|