Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: NULL sort Order
I'm not sure if this is what you want, but I'd simply do the following:
SELECT some_nullable_column
FROM some_table
ORDER BY DECODE(some_nullable_column, NULL, -1, 1) ASC;
"Ryan" <rgaffuri_at_cox.net> wrote in message
news:xdiW9.10177$I55.382247_at_news2.east.cox.net...
> Select Column
> from table
> where nvl(column,0) = 0
>
> union all
>
> what you want next, but in your where clause have
>
> nvl(column,0) != 0
>
>
> "Nati " <taldan_at_hotmail.com> wrote in message
> news:3e29feef.343050901_at_news.netvision.net.il...
> > Is there a way to cause Oracle (9.2) to sort NULL values first without
> > using NULLS FIRST pre compiler not accepting.
> >
> > TX
> >
> > Nati
>
>
Received on Tue Jan 21 2003 - 08:52:48 CST