Re: ORA-01445 Error description?

From: Steve Butler <sbut-is_at_seatimes.com>
Date: 1995/04/05
Message-ID: <Pine.SUN.3.91.950405102125.27399E-100000_at_seatimes>#1/1

On Wed, 5 Apr 1995, Marc FEIDT wrote:

> >ORA-01445: cannot select ROWID from view of more than one table
>
> If however you are trying to select from a view with more than one table then
> Oracle doesn't know anymore which rowid it should return (from table 1, 2 , 3
> ..?). Hence the following is impossible:
>
> select rowid
> from view_based_on_more_tables;
>

However, if the view had access to the original rowid's, then you could get the rowid from each table in the view. The view would have to name the rowids differently such as

     select a.rowid, b.rowid, c.rowid from a, b, c where.......

+----------------------------------------------------+
| Steve Butler          Voice:  206-464-2998         |
| The Seattle Times       Fax:  206-382-8898         |
| PO Box 70          Internet:  sbut-is_at_seatimes.com |
| Seattle, WA 98111    Packet:  KG7JE_at_N6EQZ.WA       |
+----------------------------------------------------+

All standard and non-standard disclaimers apply. All other sources are annonymous. Received on Wed Apr 05 1995 - 00:00:00 CEST