Re: Order By

was bedeuten sie?* order by sorts nulls last unless you use 'desc'. But, then, other values are also sorted in descending sequence. Use:

order by decode( the_column, null,' ', the_column)

If the_column is numeric, use 0 instead of ' '.

• criticism of my German is welcome :-)

"Klaus Zeuch" <KZeuch_at_hotmail.com> wrote in message news:8o1eil$fse$15$1_at_news.t-online.com...
> ..order by ... nulls first
> <afedirko_at_my-deja.com> schrieb im Newsbeitrag
> news:8o18sc$8ss$1_at_nnrp1.deja.com...
> > Is there a way to get Oracle to return rows with nulls before rows with
> > characters in the Order By clause besides replacing the nulls with a
> > space character?
> >
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
>
Received on Wed Aug 23 2000 - 17:05:12 CDT