Oracle SQL Syntax - Check multiple columns for IS NOT NULL Oracle SQL Syntax - Check multiple columns for IS NOT NULL oracle oracle

Oracle SQL Syntax - Check multiple columns for IS NOT NULL


sql oracle syntax

With De Morgan's law:

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

you save 20 chars ;)

NOT (weight IS NULL ORweight_unit IS NULL ORlength IS NULL ORwidth IS NULL ORheight IS NULL ORdimensional_unit IS NULL )

sql oracle syntax

As far as I know, there isn't such a syntax.

But if all of them are numeric you can use this trick:

weight + weight_unit + length + width + height + dimensional_unit is not null

sql oracle syntax 

ALTER TABLE X   ADD CONSTRAINT C_X_NN      CHECK (  (               DECODE (weight, NULL, 0, 1) +               DECODE (weight_unit, NULL, 0, 1) +               DECODE (length      , NULL, 0, 1) +               DECODE (width     , NULL, 0, 1) +               DECODE (height      , NULL, 0, 1) +               DECODE (dimensional_unit , NULL, 0, 1)               ) = 0            );

Recent Posts
How can I color dots in a xy scatterplot according to column value?
How to update a claim in ASP.NET Identity?
What does {0} mean when initializing an object?
Accessing members of items in a JSONArray with Java
How to log SQL statements in Spring Boot?
Powershell Get-WebSite name parameter is ignored
How to detect scroll to bottom of html element
Java synchronized method
How to test controllers with CodeIgniter?
Detect Visual Composer
Matplotlib: Specify format of floats for tick labels
Rails join a list of strings with commas and "and" before the last