Friday, July 27, 2007

Oracle SQLPlus number of digits to show

Do you ever want to see a really long number in an Oracle column, but SQLPlus prints out something like 2.8151+14 instead of 281510522718928? Simple fix for this one. Once per connection, just type: set num 20 That will allow up to 20 digits to be displayed. Change 20 to whatever you like, but 20 is usually larger than the number of digits I need to see.

No comments: