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

Home -> Community -> Usenet -> c.d.o.misc -> Re: update question

Re: update question

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: 27 Feb 2002 16:40:00 -0800
Message-ID: <a5ju9001fbo@drn.newsguy.com>


In article <3c7d1a39.16078802_at_news.dal.ca>, ttigger4321_at_hotmail.com says...
>
>Hi. I wonder if there are any restrictions associated with the update
>command with respect to like named columns in tables involved in the
>update. For example
>
>update table1 a
>from table2 b
>set col1 = b.col1
>where a.col2 = b.col2
>and a.col3 = b.col3
>
>returns a "ORA-00971: missing SET keyword"
>

see
http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:273215737113 for two different (ansi compliant) syntaxes that show you how to implement this SQLServer syntax in a way that all databases should be able to handle.

>oracle 8i on aix
>
>thanks
>cheers,
>tony
>494-1021 w
>461-4550 h

--
Thomas Kyte (tkyte@us.oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp 
Received on Wed Feb 27 2002 - 18:40:00 CST

Original text of this message

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