Re: SQL Update with a Join Syntax
Date: 12 Aug 2004 12:54:56 -0700
Message-ID: <18c7b3c2.0408121154.3b0949a6_at_posting.google.com>
>> What do you mean that no correlation name is allowed? You can
place a table name (correlation) label on an update, otherwise how
would you perform co-ordingated subqueries? (Code runs on Oracle 7.0 -
9.2) <<
NOT in Standard SQL; look it up!
"Caesar: Pardon him, Theodotus. He is a barbarian and thinks the customs of his tribe and island are the laws of nature." - Caesar and Cleopatra; George Bernard Shaw 1898
It would make no sense. The ANSI/ISO model is that a correlation creates a temporaty working table with that name and the data of the table expression on the left hand side of the AS operator. You also have the option of renaming the columns in the new table.
This means that the working table, not the base table, would be updated and then disappear. Received on Thu Aug 12 2004 - 21:54:56 CEST