Re: 'XYZ' AS in union query gives ORA-00918
Date: Mon, 21 Jul 2008 10:55:54 -0700 (PDT)
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)
> select 'UP' as SRC, these colums from view
> 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.
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