Help on Oracle Update statement

From: Don <don_leeNO_aa_SPAM_at_telus.net>
Date: Thu, 29 Apr 2004 18:47:28 GMT
Message-ID: <q0j290t74eannlodc70rn7ffenafudnpu8_at_4ax.com>

Hi,

I am moving from Sybase to Oracle and I used to be able to do update statement like this in Sybase:

UPDATE 	TABLE1
SET		T1.field1 = T2.field2
FROM		TABLE1 T1, TABLE2 T2
WHERE	T1.field2 = T2.field2
AND		....

but in Oracle it is not valid. Does anyone know how to convert it to Oracle?

Thanks in advance.. Received on Thu Apr 29 2004 - 20:47:28 CEST

This message: [ Message body ]
Next message: Max: "Re: New to Oracle"
Previous message: Daniel Roy: "Re: index statistics"
Next in thread: Chris Leonard: "Re: Help on Oracle Update statement"
Reply: Chris Leonard: "Re: Help on Oracle Update statement"
Reply: Mark D Powell: "Re: Help on Oracle Update statement"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message