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

From: <fitzjarrell_at_cox.net>
Date: Mon, 21 Jul 2008 10:55:54 -0700 (PDT)
Message-ID: <23ffd012-c763-4fd8-a4eb-262823104e81@w7g2000hsa.googlegroups.com>


On Jul 21, 10:13 am, Thomas Poenicke <poeni..._at_freenet.de> wrote:
> On Mon, 21 Jul 2008 06:52:53 -0700 (PDT), fitzjarr..._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

It wasn't 'nothing' if it pointed you in the correct direction for a solution.

David Fitzjarrell Received on Mon Jul 21 2008 - 12:55:54 CDT

Original text of this message