UPDATE problem - FROM Clause not supported in Oracle

Hi,
I want to have a single statement to work on both sql server and oracle, but am not able to convert the following to do so. I am trying to update a column

UPDATE field_char f SET maxLength = 254

FROM field_char fc, arschema s

WHERE f.fieldid IN('2', '4', '5', '101', '105', '117', '118')

AND (s.schemaId = fc.schemaId)

AND (s.schemaType = 1)

But it seems that the FROM clause is not supported in Oracle,

Thanks for any help
dsriva Received on Tue Jul 26 2005 - 09:53:32 CDT