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: damorgan <dan.morgan_at_ci.seattle.wa.us>
Date: Wed, 27 Feb 2002 22:45:07 GMT
Message-ID: <3C7D6175.C5447037@ci.seattle.wa.us>


Please take this not as a personal criticism but rather as a general statement appliable to many developers that come to Oracle from other RDBMS products.

Oracle is not what you used to work in with another name on the CD.

There is likely absolutely nothing you have ever done in any other RDBMS that can not be done in Oracle ... though the method of doing it will likely be different.

Different is not bad. Different is not good. Different is just different.

You will never be able to effectively work in Oracle if you do not RTFM.

But you will anger a lot of people who could help you if you translate "your personal lack of knowledge" into "Oracle can't do it." Look in books, search at http://technet.oracle.com, ask experts then, and only then, make pronouncements.

Which is a long way of saying ... you are incorrect!

Daniel Morgan

tony wrote:

> 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 - 16:45:07 CST

Original text of this message

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