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!

Exclude null columns in query

M TajuddinJul 15 2009 — edited Jul 20 2009

Hi Gurus,
I need your help here. I have a table containing more than 120 columns. Now i want to produce a report only for those columns those are not null. How can I accoplish this??

Is there any way, to display the results as following -

Table structure -
col1 col2 col3 col4 col5 col6 col7 col8
A     B      A    C            D        D

col5 and col8 does not have any value, so i want to display resutl like this -
col1 A
col2 B
col3 A
col4 C
col6 D
col7 D

Thanks in advance,

Regards,
M Tajuddin

This post has been answered by William Robertson on Jul 20 2009

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 17 2009

Added on Jul 15 2009

25 comments

24,818 views