Re: Weird ORACLE update statement

From: Richard G Ramirez <ramirez_at_IASTATE.EDU>
Date: Tue, 8 Dec 1992 19:50:07 GMT
Message-ID: <1992Dec8.135007_at_IASTATE.EDU>


An involved solution that works is to
create a Temporary table with the rows to be updated, then delete those rows, and
insert them with the new values.

Not elegant, certainly, but solves the problem. Of course you can write aC program and use a cursor.

I seem to remember that INGRES allowed multiple tables in UPDATE, that doesn't help you, I know, but it may be interesting to know. Received on Tue Dec 08 1992 - 20:50:07 CET

Original text of this message