开发者

PL/SQL procedure with cursors

开发者 https://www.devze.com 2023-03-06 20:44 出处:网络
I need to check whether any of the column in record set contains data or not. I have to check 10 columns for the data.If data is not there it has to exit oth开发者_运维百科erwise continue to the nex

I need to check whether any of the column in record set contains data or not.

I have to check 10 columns for the data. If data is not there it has to exit oth开发者_运维百科erwise continue to the next step.


Try COALESCE(col_1,col_2,.....) IS NOT NULL

0

精彩评论

暂无评论...
验证码 换一张
取 消