Table has 6 columns. One of the column say date contains
date and null values. The same column I want to print in
two columns as date and null headers with the values (if
there is a date I want to print date as a date with date
header, the null columns in a separate column with null
header) and also all other columns. So totally it becomes
7 columns. Can someone please help me. Thanks

Suj

hi suj,

Can you post ddl/some sample records and expected resultset.

-Vishal