Re: NULL sort Order

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 Sat Jan 18 2003 - 13:49:49 CST