Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: Do we always have to update or insert? Why can't we just relate?

Re: Do we always have to update or insert? Why can't we just relate?

From: David Portas <REMOVE_BEFORE_REPLYING_dportas_at_acm.org>
Date: 14 Oct 2005 06:34:54 -0700
Message-ID: <1129296894.441126.94770@g14g2000cwa.googlegroups.com>


> But there is still the conceptual part of my question. Do we really
> need insert and update?

No. Relational assignment is all you need for updates, inserts, deletes. According to both Codd and Date an RDBMS should support relational assignment. A "D" language must support relational assignment - it's a requirement. SQL does not support it.

-- 
David Portas 
SQL Server MVP 
--
Received on Fri Oct 14 2005 - 08:34:54 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US