Re: Help with query order

hasta_l3_at_hotmail.com wrote:
> I cant get the results of the following query correctly ordered.
> Any help would be much appreciated (10.2.0.1)
>
> select 'Merry ' from dual
> union
> select 'Christmas ' from dual
> union
> select 'dear ' from dual
> union
> select 'group ' from dual
>
> --- Raoul :-)

assuming sqlplus

column volgorde noprint
select 1 volgorde, 'Merry'
from dual
union
select 2, 'Christmas'
from dual
union
select 3, 'dear '
from dual
union
select 4, 'group'
from dual
order by volgorde

-- 
Sybrand Bakker
Senior Oracle DBA