Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!news.he.net!news-hog.berkeley.edu!ucberkeley!newsfeed.stanford.edu!postnews1.google.com!not-for-mail
From: pchemes@inalambrik.com.ar (PABLO)
Newsgroups: comp.databases.oracle.misc
Subject: Re: Migrating from SQL server
Date: 10 Oct 2002 12:55:22 -0700
Organization: http://groups.google.com/
Lines: 29
Message-ID: <fb04eea9.0210101155.715de63@posting.google.com>
References: <fb04eea9.0210090923.2c2a5c5f@posting.google.com> <3DA46770.D5F2A534@exesolutions.com>
NNTP-Posting-Host: 200.61.161.137
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1034279722 17624 127.0.0.1 (10 Oct 2002 19:55:22 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 10 Oct 2002 19:55:22 GMT
Xref: newsfeed1.easynews.com comp.databases.oracle.misc:87683
X-Received-Date: Thu, 10 Oct 2002 12:55:17 MST (news.easynews.com)

Thanks Daniel, but it is still not working for me... I need to specify
the WHERE clause of the UPDATE/SET matching some value I get in the
inside SELECT, as I wrote in the example.

Do u know how to do it ?
thanks,
Pablo

Daniel Morgan <dmorgan@exesolutions.com> wrote in message news:<3DA46770.D5F2A534@exesolutions.com>...
> PABLO wrote:
> 
> > Hi, I am trying to migrate this query from SQL server to Oracle 9i and
> > I can not find a way to solve it.
> >
> > Does someone have and idea of how to do it ?
> >
> > Thanks a lot in advance.
> > Pablo
> >
> > UPDATE Table1
> > SET FieldA = b.FieldB
> > FROM ( SELECT Exp as FIledB, Exp as FieldC FROM ... WHERE.... ) As B
> > WHERE Table1.FieldA <> b.FieldB
> > AND   Table1.Field> >= b.fieldC
> 
> UPDATE table1
> SET FieldA = SELECT fieldB FROM ...
> 
> Daniel Morgan