There is no error message. It is a discrepancy found out by comparing the following:
Inserted a value 0.16810240488058710806053994064187 into a field
defined as NUMBER(22,16)
Here, Oracle should round off the value automatically.
When the field in a simple sql statement in TOAD was selected , <0.
168102404880587> is returned.
<0.1681024048805871> was expected instead; 16 decimal places.
Does TOAD do further rounding/truncation? If yes, how can the precision be controlled or expanded?
You need to be signed in and under a current maintenance contract to view premium knowledge articles.