Re: 'XYZ' AS in union query gives ORA-00918

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) as
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.

Regards
Thomas Received on Mon Jul 21 2008 - 10:13:36 CDT