How to find NULL values in a Table

Database
Enthusiast

How to find NULL values in a Table

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?

Tags (1)