一般常规通过 xx is null判断,如何多列不方便,可以看他的NUM_DISTINCT 值是否为0来判断;
select distinct aa.COLUMN_NAME
from all_tab_columns aa
where aa.TABLE_NAME in ('XXXXX' )
and aa.NUM_DISTINCT = 0;
一般常规通过 xx is null判断,如何多列不方便,可以看他的NUM_DISTINCT 值是否为0来判断;
select distinct aa.COLUMN_NAME
from all_tab_columns aa
where aa.TABLE_NAME in ('XXXXX' )
and aa.NUM_DISTINCT = 0;