Connected to an Oracle 11g database. Querying a table that has null rows for both varchar2 and number datatypes. Using various SQL function queries on the null column do not display the {null} value in the data grid.
Using the following queries:
SELECT * from nulltbl;
SELECT MIN(name) FROM nulltbl;
SELECT MIN(units) FROM nulltbl;
SELECT MAX(name) FROM nulltbl;
SELECT MAX(units) FROM nulltbl;
SELECT AVG(name) FROM nulltbl;
SELECT AVG(units) FROM nulltbl;
SELECT MAX(LENGTH(name)) from nulltbl;
SELECT MAX(LENGTH(units)) from nulltbl;
- Varchar2 datatypes show {null}, but Number shows as blank cell.
- AVG() function shows blank for both datatypes
- MAX(LENGTH()) shows blnak for both dataypes
If truly NULL values for all data, then expecting to see {null} for all the queries.
