Re: UPDATE problem - FROM Clause not supported in Oracle

From: Maxim Demenko <mdemenko_at_arcor.de>
Date: Tue, 26 Jul 2005 17:09:03 +0200
Message-ID: <42e65319$0$20137$9b4e6d93@newsread2.arcor-online.net>

dsriva schrieb:
> Hi,
> I want to have a single statement to work on both sql server and
> oracle,

In most cases a bad idea (IMHO)
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
>

Seems me too...
http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_10007.htm#i2112182

Best regards

Maxim Received on Tue Jul 26 2005 - 10:09:03 CDT