Re: UPDATE with Oracle ??? with join ???
From: mcstock <mcstockspamplug_at_spamdamenquery.com>
Date: Wed, 19 Nov 2003 17:42:28 -0500
Message-ID: <DZOdnbP3w6Z5bCaiRVn-tw_at_comcast.com>
Date: Wed, 19 Nov 2003 17:42:28 -0500
Message-ID: <DZOdnbP3w6Z5bCaiRVn-tw_at_comcast.com>
[Quoted] "Malcolm Dew-Jones" <yf110_at_vtn1.victoria.tc.ca> wrote in message
news:3fbbe8b6_at_news.victoria.tc.ca...
| 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.
|
| 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.
|
this works in v7 (at least in 7.3.4)
- mcs