Is there a way to force maximum digits for a result decimal
A
Andrew Chandler
started a topic
14 minutes ago
I'm trying to figure out a way to easily see result columns from an oracle query that maybe have more than 16 digits total. The underlying oracle database supports much more than this but I'm troubleshooting other systems the data flows to. I remember in older versions that if the number got too large it used to display engineering notation for that cell but newer versions seem to just happily show the entire number. Is there a way for me to force the cell's to show no more than 16 digits and user engineering notation if the number is too large or has too many decimals?
1 Comment
A
Andrew Chandler
said
11 minutes ago
To clarify - I want to be able to notice that the digit count including decimal point is > 16 without having to manually count them. DB Visualizer IS displaying the larger values quite well but they blend in to all the other numbers.
Andrew Chandler
I'm trying to figure out a way to easily see result columns from an oracle query that maybe have more than 16 digits total. The underlying oracle database supports much more than this but I'm troubleshooting other systems the data flows to. I remember in older versions that if the number got too large it used to display engineering notation for that cell but newer versions seem to just happily show the entire number. Is there a way for me to force the cell's to show no more than 16 digits and user engineering notation if the number is too large or has too many decimals?