is simple oracledb or oracledb delete null column result ? about simple-oracledb HOT 4 CLOSED

you sure the properties are missing and not there with value of type undefined?
I have a test that inserts 2 rows and sets 4 columns for each row. but the table holds 6 columns.
In the query output, i get all 6 columns where the other 2 are set to undefined.
You can see the test code here:

from simple-oracledb.

yes it's my fault they are undefined.
is that any way to return empty string instead of undefined ?

from simple-oracledb.

oracle (and i'm not close to be an expert like the oracle team) has no concept of empty string.
when you insert empty string, it pushes null.
so when you query, you can't query by empty string, you query by is null.
so when you pull data that is 'empty string' it is basically null.
so in my layer, i always get undefined, no matter if you pushed empty string or null, because it is always stored in the db as null.
one of those strange oracle behaviors.

from simple-oracledb.

thanks your says are very useful

from simple-oracledb.