When I execute the below query, I am getting '#' values for some records in some columns. These columns use TO_CHAR function to round off the values to 2 or 4 decimal places and after adding the TO_CHAR function the values are displayed as below.
I suspect that this has something to do with the column size but not sure where to modify. I am using Oracle SQL Developer.
Any idea on this is very much appreciated.