We have a table where the primary key is defined as a NUMBER(20) and the contents typically contain 20 digit numbers (no leading zeroes). Every time I query the table within PLSQL Developer, the primary key column is truncated so we have to do a TO_CHAR on the primary key in order to retrieve it.
So as an example, by running the below query, I get the below result.
Query : SELECT to_number('12345678901234567890') AS NBR FROM dual
Result : 1.23456789012346E19
Converting the column from a NUMBER to a VARCHAR is not a quick option available to us and having to TO_CHAR the column every time I query it is a bit of a pain hence why I am hoping there is a quick win available.
So is anyone aware of any option within PLSQL Developer which would mean I can increase the length of the visible digits before truncation takes place ? If not, are there any other suggestions anyone can thing of ?
A colleague of mines uses SQL Developer and it doesn't truncate any numbers regardless of length, or at least it didn't when we tried it on a 40 digit number.
Thanks.
Gav.