Re: Can I select(*) from T only fields that are not null?

In message <1118258131.376943.26520_at_g47g2000cwa.googlegroups.com>, deanbrown3d <deanbrown3d_at_yahoo.com> writes
>Can I get a select(*) statement to give back only the fields that have
>data?
>
>
>(I'm running this is SQL plus worksheet, on server 9, client 10)
>
>Thanks,
>
>Dean
>

You can't do it the way you want to.
Possibly the best solution is to use
set null #### (or some other distinctive string) and/or
set colsep , (a comma)

The first lets you see the null columns and distinguishes them from white space.
The second gives you a field separator that awk or something can work on to edit out the nulls.

-- 
Jim Smith
Because of their persistent net abuse, I ignore mail from
these domains (among others) .yahoo.com .hotmail.com .kr .cn .tw
For an explanation see <http://www.jimsmith.demon.co.uk/spam>