Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Migrating from SQL server
PABLO wrote:
> 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
Go to http://tahiti.oracle.com
Enter the search criterion "UPDATE"
Scroll down to 'SQL Reference' - click on it
Scroll down to 'Set Operators - SELECT and subquery' - click on it
Did you really need me to tell you this after the hundreds of times I, and others, have said presented this resource in this and the other usenet groups?
Daniel Morgan Received on Thu Oct 10 2002 - 16:13:29 CDT