Re: [Q] Why cant I ORDER BY on a SELECT...UNION in PL/SQL

Hi Quentin,

Try this:

select col1,col2 from tab1
union
select col1,col2 from tab2
order by 1;

                        Andrew Protasov

Quentin North wrote in message
<888240456.3424.0.nnrp-06.9e98628b_at_news.demon.co.uk>...
>Why wont this work in pl/sql (but will otherwise):
>
>select col1,col2 from tab1
>union
>select col1,col2 from tab2
>order by col1;
>
>Get message PLS-00423: ORDER BY item must be the number of a SELECT-list
>expression
>
>Oracle support in the UK dont appear to know why it wont work. Everything
>works until you add the order by clause.
>
>
Received on Mon Feb 23 1998 - 00:00:00 CET