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

From: Thomas Poenicke <>
Date: Mon, 21 Jul 2008 17:13:36 +0200
Message-ID: <g6292v$fho$>

On Mon, 21 Jul 2008 06:52:53 -0700 (PDT), 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.

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

Original text of this message