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: Q: Does any ANSI-SQL standard address multi-column updates ?

Re: Q: Does any ANSI-SQL standard address multi-column updates ?

From: Kendall <kendall_at_localhost.localdomain>
Date: Wed, 13 Feb 2002 10:36:02 -0800
Message-ID: <u6lcgiionmng11@news.supernews.com>


How about something like

select * from tab where (a,b,c) > (1,2,3)

?

In article <c0d87ec0.0202121305.df95b27_at_posting.google.com>, "--CELKO--" <71062.1056_at_compuserve.com> wrote:
>
> The SQL-99 standard has syntax for a row constructor in the UPDATE
> statement; you can get a book on SQL-99 from Amazon.com or Fatbrain.com
> for details. Working from memory, it is something like:
>
> UPDATE Target
> SET ROW (a,b,c,..)
> = (SELECT x,y,z, ... FROM Source WHERE ...)
> WHERE ...;
Received on Wed Feb 13 2002 - 12:36:02 CST

Original text of this message

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