Oracle SQL语法-检查多个列是否为IS NULL [英] Oracle SQL Syntax - Check multiple columns for IS NOT NULL

问题描述

是否有更简洁的语法来检查多个列是否不为null?我想简化

Is there a more concise syntax for checking whether multiple columns are not null? I'm looking to simplify

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(如果相关).

Using Oracle, if it's relevant.

推荐答案

使用迪摩根定律:

不是(A或B)=(不是A)和(不是B)

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 
)

这篇关于Oracle SQL语法-检查多个列是否为IS NULL的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！