Re: update question

From: tony <ttigger4321_at_hotmail.com>
Date: Wed, 27 Feb 2002 19:40:36 GMT
Message-ID: <3c7d3511.22951068@news.dal.ca>

I've since discovered that oracle doesn't support this type of update as do many (most?) other dbms. It was a simple question soliciting only a simple answer. I hate to be baited, but today I'm in the mood.

On Wed, 27 Feb 2002 19:13:54 GMT, damorgan <dan.morgan_at_ci.seattle.wa.us> wrote:

>I would suggest that you start with a book on beginning SQL.
>
>update table1 a
>from table2 b
>
>isn't going to get you very far.
>
>Daniel Morgan
>
>
>
>tony wrote:
>
>> 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"
>>
>> oracle 8i on aix
>>
>> thanks
>> cheers,
>> tony
>> 494-1021 w
>> 461-4550 h
>

cheers,
tony
494-1021 w
461-4550 h Received on Wed Feb 27 2002 - 13:40:36 CST