Display NULL value

[sthaler]

Is there some setup option or some other trick so I can see fastly the difference if a data field contains blanks or null ?
This is the only reason why sometimes I have to use SQL*Plus (there I use SET NULL "?")
Thanks for any help
Sepp

 

[Marco Kalter]

The only way to see this is:

1. Select the data to verify if there are any spaces.

or

2. Use an nvl expression in your query.

A "set null" option would be nice though...

------------------
Marco Kalter
Allround Automations

 

[sxgoodman]

It would be nice to have such an option. Using the NVL function everytime is extremely cumbersome, especially if there are a lot of affected variables.

My colleague's RapidSQL automatically puts [null] in those queried fields.

Any chance of adding this during the next release?

Thanks,

------------------
sxg

 

[Marco Kalter]

This is indeed on the list of enhancement requests.

------------------
Marco Kalter
Allround Automations

 

[lual]

...i agree. this feature would be very, very useful.

sugestion : maybe the backgroundcolor of cells containing NULL values should be different instead of filling it with the word "NULL".

question : is the list of enhancement requests public? where can i find it?

 

[Marco Kalter]

sugestion : maybe the backgroundcolor of cells containing NULL values should be different instead of filling it with the word "NULL".

I agree. A visual clue that does not affect the contents is the best solution.

question : is the list of enhancement requests public? where can i find it?

Not yet. We are looking for The Right Tool to make things public.

 

[sthaler]

Originally posted by Marco Kalter:
[QB]

sugestion : maybe the backgroundcolor of cells containing NULL values should be different instead of filling it with the word "NULL".

I agree. A visual clue that does not affect the contents is the best solution.

I agree with Marco Kalter and lual. A visual clue is the best solution
Best regards
Sepp