columns with too large values not shown
791901Aug 17 2010 — edited Aug 18 2010Hi,
When comparing the results of a simple SELECT * FROM ... query between TOAD and SQL Developer, I noticed a difference in results:
Whenever a column was defined as NUMBER(12), but 13 digits had been inserted, the values would be shown correctly in TOAD, but shown erroneously in SQL Developer.
Example: SELECT SUPV_TE_MSG_OUT_COUNT, supd_te_last_succ_dc_cdc_datyy, SUPV_TE_BAL_PER_NR, SUPV_TE_SESSION_NR_PREV
FROM W_LOGGING_SUPV
--> result in TOAD: 25190, 2060000000637, 20600, 12007
--> result in SQL DEV: 00, 0000000637, 00, 11900
My question: is this
- a bug to be squished?
- an approach which will remain?
- a behavior which can be changed?
Note: the behavior on inserting too large values will be changed in any case, but the SQL Developer behavior makes it more difficult to spot the problem.
Thank you and regards,
Peter