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!

Query to get only not null columns

4016797Jul 25 2019 — edited Jul 27 2019

Hello All,

I have a table where some of the columns will have values (not null) and some of them are null (no value) like below. Now I want to return columns in the select query which will have values (Not null).

Can anyone please suggest how to proceed?

pastedImage_0.png

This post has been answered by Paulzip on Jul 26 2019
Jump to Answer
Comments
Post Details
Added on Jul 25 2019
25 comments
16,270 views