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,
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:
but in Oracle it is not valid. Does anyone know how to convert it to
Oracle?
Thanks in advance..
UPDATE TABLE1
SET T1.field1 = T2.field2
FROM TABLE1 T1, TABLE2 T2
WHERE T1.field2 = T2.field2
AND ....