我有一个名称为Shipment的表,其中的列为HAWB, MAWB。如何检查这两列是否为空值?

最佳答案

要查找HAWB为空的行:

SELECT * FROM Shipment WHERE HAWB IS NULL;


要查找MAWB为空的行:

SELECT * FROM Shipment WHERE MAWB IS NULL;


如果要查找HAWB不为空的行:

SELECT * FROM Shipment WHERE HAWB IS NOT NULL;


最后,如果要查找MAWB不为null的行:

SELECT * FROM Shipment WHERE MAWB IS NOT NULL;

关于java - 如何在plsql中检查列值是否为null?,我们在Stack Overflow上找到一个类似的问题:https://stackoverflow.com/questions/6148180/

10-12 12:35
查看更多