Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Query from SQL SErver

Query from SQL SErver

From: PABLO <pchemes_at_inalambrik.com.ar>
Date: 9 Oct 2002 10:23:25 -0700
Message-ID: <fb04eea9.0210090923.6ed3a91a@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:25 CDT

Original text of this message

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