Re: UPDATE with Oracle ??? with join ???
From: Malcolm Dew-Jones <yf110_at_vtn1.victoria.tc.ca>
Date: 19 Nov 2003 14:03:34 -0800
Message-ID: <3fbbe8b6_at_news.victoria.tc.ca>
Date: 19 Nov 2003 14:03:34 -0800
Message-ID: <3fbbe8b6_at_news.victoria.tc.ca>
[Quoted] [Quoted] Daniel Morgan (damorgan_at_x.washington.edu) wrote:
: SQL> UPDATE (SELECT * FROM channels WHERE channel_desc = 'Catalog') : 2 SET channel_desc = 'X';
That's lovely! though I guess it's new in version 9.
[Quoted] You check your criteria using the 100% safe select, and then run the _identical_ statement in the "dangerous" step of modifying data.
I plan to lookup
DELETE FROM (SELECT...) to see if that works
though direct answers as to whether that is also supported would be available for all to read. Received on Wed Nov 19 2003 - 23:03:34 CET