Display all NULL columns

hm_naveen · January 4th, 2007, 10:20 AM

Hi,

I have a doubt how to get the following output in PL/SQL.

There are 100 columns in a table display all NULL columns of row.

peace95 · January 4th, 2007, 10:41 AM

hm_naveen:
You will have to loop thru each column in each row and test for "if NULL exist". The loop is iterated after the defined CURSOR has selected the table.

Hope this helps.

hm_naveen · January 5th, 2007, 09:50 AM

Thank you very much for your response.

But how to get the number of columns in a table(dynamically)