On Sat, 07 Aug 2004 10:24:34 -0400, Jan Wieck <JanWieck@Yahoo.com>
wrote:
>I have not heard of "updatable subselects" yet.
http://asktom.oracle.com/pls/ask/f?p=4950:8:6693556430011788783::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:273215737113,
| Here we update a join. [...]
| scott@ORA734.WORLD> update
| 2 ( select columnName, value
| 3 from name, lookup
| 4 where name.keyname = lookup.keyname
| 5 and lookup.otherColumn = :other_value )
| 6 set columnName = value
| 7 /
Google fororacle "delete statement" syntax
ororacle "update statement" syntax
ServusManfred