oracle判断字段为空时选用别的字段_如何动态判断一个表的多个字段值是否为空...

问题解决：

--循环每一列

FOR cc IN (SELECT utcs.Column_NAME

FROM User_Tab_Columns utcs

WHERE utcs.TABLE_NAME = UPPER('cux_items_temp1')) LOOP

L_Curr_Col_Name := cc.Column_name;

--循环每一行

FOR L_Loop_Number IN 2..L_Total_Rows+1 LOOP

--如果为空替换为######

L_Exec_Sql :=  'SELECT DECODE('||L_Curr_Col_Name||',null,''######''),b.line1 FROM (SELECT '

||L_Curr_Col_Name||',a.line line1 FROM cux_items_temp1 a WHERE ROWNUM

||L_Loop_Number||' ORDER BY a.line DESC) b WHERE ROWNUM =1';

--读取出当前的行列交集的值和行号

L_Curr_Col_Value := NULL;

L_Curr_Line      := NULL;

EXECUTE IMMEDIATE L_Exec_Sql

INTO L_Curr_Col_Value,L_Curr_Line;

--

IF(L_Curr_Col_Value='######') THEN

--输出日志，定位错误信息

L_Msg_Flag :=L_Msg_Flag+1;

wl_iface_pkg.to_log('Message '||to_char(L_Msg_Flag)||':Row:'

||to_char(L_Loop_Number-1)||' Column:'

||to_char(L_Curr_Col_Name)||' is null,please check!',2,'*');

END IF;

END LOOP;

END LOOP;

COMMIT;