PL/SQL procedure with cursors

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