Now have such a scenario, I want to be in the lookup table data, requires a few field is not null, that is, is not null, only because is just contact is added behind each field is not null, so much more fields will write a lot of repetition, excuse me is there a simple bit of writing, is a table

CodePudding user response:

Honestly, written this lazy idea is good, but it seems unlikely,

CodePudding user response:

Didn't have

CodePudding user response:

Where decode (null, col1, 1, col2, 1, 2)=1