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 :-)

Perhaps this will help.

WITH q AS (SELECT ' the season' AS SUFFIX from dual) SELECT 'Hope all are enjoying' || suffix FROM dual, q;

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org