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>
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