Oracle is not null as the query conditions and what is the difference between the query results?

CodePudding user response:

Can explain what is not null as the query result is

CodePudding user response:

Refers to a null null and matching, and is not a null string matching?

CodePudding user response:

Is to select the name is not null from tb_user and select the name from tb_user where the name is not null

CodePudding user response:

refer to the second floor qq_38818136 response:

refers to a null null and matching, and is not a null string matching?

Is to select the name is not null from tb_user and select the name from tb_user where the name is not null

CodePudding user response:

Haven't seen this writing the select the name is not null from tb_user

CodePudding user response:

Where is the query condition is not Null writing

CodePudding user response:

reference 5 floor wildwolv reply:

have not seen this writing the select the name is not null from tb_user

It is no problem in my SQL database but in oracle complains so I want to know the difference

CodePudding user response:

Problem is inside the ORACLE didn't select the name is not null from tb_user this kind of writing, how to say the difference

CodePudding user response:

refer to the eighth floor yaiger response:

problem is inside the ORACLE didn't select the name is not null from tb_user this kind of writing, how to say the difference between

So is not null can only write behind the where