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

[Quoted] [Quoted] Why wont this work in pl/sql (but will otherwise):

select col1,col2 from tab1
union
select col1,col2 from tab2
[Quoted] order by col1;

[Quoted] Get message PLS-00423: ORDER BY item must be the number of a SELECT-list expression

[Quoted] Oracle support in the UK dont appear to know why it wont work. Everything [Quoted] works until you add the order by clause. Received on Mon Feb 23 1998 - 00:00:00 CET