I have a table of having 260 columns in that i need to retrieve the records having NULL values. I had seen my DDL also, few of the columns
having NULL Constraint, so i left those columns in my query. My Query is
SEL * FROM TableName WHERE CN1 is NULL or CN2 is NULL or CN3 is NULL... or CN260 is NULL
Is there any other method to find the NULL values from all the columns?
rights to materials on this website, the rights you grant to your submissions to this website, and your responsibilities regarding your conduct on this website.