Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to find only Null value record fields in a table

User_UMJZ5Mar 18 2021

Hi All,
I have one table with more than 200 columns and millions of records but i want to check list of fields which are having only nulls,.if i use below query will get result but need to add all columns in where clause is there any way to find nulls.
Select * from table
where col1 is null or col2 is null

Thx

Comments
Post Details
Added on Mar 18 2021
1 comment
5,289 views