UNION ORDER BY 00904. 00000 - "%s: invalid identifier"
976692Nov 28 2012 — edited Nov 28 2012I'm using 11g R2 64bit
Why this does not execute ?
select 1 a from dual
union
select 2 from dual
union
select 3 from dual
order by a
;
ORA-00904: "A": invalid identifier
00904. 00000 - "%s: invalid identifier"
*Cause:
*Action:
Error at Line: 16 Column: 9
This works fine:
select 1 a from dual
union
select 2 a from dual
union
select 3 a from dual
order by a
;
And this works:
select 1 a from dual
union
select 2 from dual
--union
--select 3 from dual
order by a
;