Re: Yet another newbie question

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Wed, 2 Sep 2009 17:17:45 +0200
Message-ID: <4a9e8c9a$0$25288$426a74cc_at_news.free.fr>


"Sashi" <smalladi_at_gmail.com> a écrit dans le message de news: f4b15387-b8cc-4ce9-a9d2-fb8d74d88e1f_at_w36g2000yqm.googlegroups.com...
| Hi all,
| I'm using a standard SQL command but Oracle seems to have a different
| version.
|
| update A,B
| set a.col1 = 'something'
| where a.col2>=b.col2 and a.col3<=b.col3
|
| Why doesn't this seem to work?
|
| Thanks,
| Sashi

Because it is not in the Oracle SQL syntax. http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_10007.htm#i2067715

Regards
Michel Received on Wed Sep 02 2009 - 10:17:45 CDT

Original text of this message