Hi Team,
We have a SQL report where the data is displayed blank space if there is a null value in the field as below,
NVL(Columnname, ' ')
Now the requirement is that to not to display blank space instead there should be nothing into that field if it is empty but it should also not display "?" value. Now what I know is if the value is null then it will display "?" while extracting the content and the only way is to replace it with the null value as mentioned above. But before I go ahead and confirm back to business I won't to check if there is a way to display blank instead of null value and also there should not be a space or anything.
Thanks,
Nikhil Sanghvi