Comparison of two null values of oracle and comparison of two empty strings
This article introduces the knowledge of "the comparison of two null values of oracle and the comparison of two empty strings". In the operation of actual cases, many people will encounter such a dilemma, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!
Null=null and'= 'are both false, so no data will be queried
The correct way to write it can be nvl (null,'1') = nvl (null,'1')
This is the end of the comparison of two null values of oracle and the comparison of two empty strings. Thank you for reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!