Re: Migrating from SQL server

From: PABLO <pchemes_at_inalambrik.com.ar>
Date: 10 Oct 2002 12:55:22 -0700
Message-ID: <fb04eea9.0210101155.715de63@posting.google.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_at_exesolutions.com> wrote in message news:<3DA46770.D5F2A534_at_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
Received on Thu Oct 10 2002 - 14:55:22 CDT