sql - Oracle SQL 语法 - 检查多个列是否为 IS NOT NULL

Question

是否有更简洁的语法来检查多列是否不为空？我想简化

weight IS NOT NULL AND
weight_unit IS NOT NULL AND
length IS NOT NULL AND
width IS NOT NULL AND
height IS NOT NULL AND
dimensional_unit IS NOT NULL

变成更短的东西。

使用 Oracle(如果相关)。

Answer 1

与 De Morgan's law :

NOT (A OR B) = (NOT A) AND (NOT B)

你节省了 20 个字符；)

NOT (
weight IS NULL OR
weight_unit IS NULL OR
length IS NULL OR
width IS NULL OR
height IS NULL OR
dimensional_unit IS NULL 
)