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 -> Migrating from SQL server

Migrating from SQL server

From: PABLO <pchemes_at_inalambrik.com.ar>
Date: 9 Oct 2002 10:23:55 -0700
Message-ID: <fb04eea9.0210090923.2c2a5c5f@posting.google.com> 





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
Received on Wed Oct 09 2002 - 12:23:55 CDT












Original text of this message













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