Re: Suggestions on a good way to write an Update with a join

From: <smb_slb_at_my-dejanews.com>
Date: Wed, 19 May 1999 14:22:35 GMT
Message-ID: <7huhf7$2rh$1@nnrp1.deja.com>

I don't think this works. When I try it I get this error:

ORA-02324: more than one column in the SELECT list of THE subquery

Anyway, doesn't the THE operator indicate that the query in question returns a single row? What I'm trying to do involves updating an arbitrary number of rows (although I realize the example I gave implies that it is a single row update).

In article <3741E7FA.D64582F5_at_hotmail.com>, Uppili <sestri_at_hotmail.com> wrote:
> Hi,
> Try using the Oracle8 feature for this.
>
> Update THE( Select x, y, z , x1, y1 ,z1 from Table A , Table B where
> ...........)
> Set x = x1 ,
> y = y1,
> z = z1
>
> You should use the 'THE'.
>
> For more information check the documentation..
> ..../ORANT/doc/server803/A54641_01/ch4.htm..
>
>

--== Sent via Deja.com http://www.deja.com/ ==-- ---Share what you know. Learn what you don't.--- Received on Wed May 19 1999 - 09:22:35 CDT