Re: 'XYZ' AS in union query gives ORA-00918
Date: Mon, 21 Jul 2008 17:13:36 +0200
On Mon, 21 Jul 2008 06:52:53 -0700 (PDT), fitzjarrell_at_cox.net wrote:
I think, the mistake lies in the dirty glasses, covering the top line of the view declaration.
Here the solution:
create or replace view (columns in table and view)
select 'UP' as SRC, these colums from view union
select 'DB' as src, those columns from table
I just forgot to add "SRC" in the header line.
Sorry for the time you spent for nothing.
Thomas Received on Mon Jul 21 2008 - 10:13:36 CDT