我有一个名称为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/