Re: UPDATE problem - FROM Clause not supported in Oracle

From: Matthias Hoys <idmwarpzone_NOSPAM__at_yahoo.com>
Date: Sat, 30 Jul 2005 13:51:07 +0200
Message-ID: <42eb69ab$0$17560$ba620e4c@news.skynet.be>

"dsriva" <dsrivast_at_gmail.com> wrote in message news:1122389612.926329.57260_at_o13g2000cwo.googlegroups.com...
> 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
>

What's the point of doing this ? Are you developing a database-independent application ? I would say : bad idea. You should use the optimal features for both engines. Also, SQL features can change between versions. Database independent development leads to performance and scalability problems. One example : to create a table with sequence numbers instead of using autonumbers (SQL Server) or sequences (Oracle).

Matthias Received on Sat Jul 30 2005 - 06:51:07 CDT