Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Keeping SQL Developer 4.0's Display Null Values during export

Kurt HarlessAug 24 2016 — edited Aug 26 2016

Greetings,

In SQL Developer 4.0 I have my Pref > Database > Advance > Display Null value as (null)  **Pretty sure that was the default value

My Query Results Report Grid show NULLs as (null).... Perfect!

When I export (or copy / paste)  to any formatted file type, tried them all, data that shows up as "(null)" in my Query Results Report Grid is now just a single space, " "...

I am trying to provide QA Testing reports to another department and although I could solve this writing SQL and formatting the output for every column, I would rather just export or copy /paste into excel to produce my proofs.

Is their a preference for this behavior I am not seeing?

Kurt

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 23 2016
Added on Aug 24 2016
6 comments
2,264 views