Home > database >  Oracle, the difference between 0 and null
Oracle, the difference between 0 and null

Time:09-21

Collecting data, all have some of the field data show is 0, but the collection is null, the other fields without change, way,

CodePudding user response:

What? 0 is Numbers or strings, Null is not what it means to be a Null value

CodePudding user response:

Under the field value is 0, after collected is null, how to write a grammar? Directly select seems to be no

CodePudding user response:

What is the meaning of collected?

CodePudding user response:

How to collect,,,

CodePudding user response:

Is directly from a library collection to another library, grammar is simple, is to select from

CodePudding user response:

Anyway, the result is the value of the other fields are not changed, but only under the field of 0, the equivalent of no data, select is null, is filtered? But I don't know how to filter

CodePudding user response:

0 is represent Numbers, null is of value, the two are not the same,

CodePudding user response:

The select statement posted a look, what is the filter