Re: UPDATE SET query Oracle 9i

From: Hans Weil <hans.weil_at_web.de>
Date: Tue, 2 Sep 2003 09:22:59 +0200
Message-ID: <bj1ggj$e461q$1@ID-12190.news.uni-berlin.de>

Hi Henk,

> SQL> UPDATE t_connector SET StyleEx =
> 2 (SELECT 'FKS=' || ps.Name || ':;FKT=' || pt.Name || ':;'
> 3 FROM t_operation os, t_operation ot, t_operationparams ps,
t_operationparams pt
> 4 WHERE os.OperationID = ps.OperationID
> 5 AND c.Start_Object_ID = os.Object_ID
> 6 AND os.Stereotype = 'FK'
> 7 AND ot.OperationID = pt.OperationID
> 8 AND c.End_Object_ID = ot.Object_ID
> 9 AND ot.Stereotype = 'PK')
> 10 AND t_connector.Connector_ID = c.Connector_ID;
> AND t_connector.Connector_ID = c.Connector_ID
> *
> ERROR at line 10:
> ORA-00933: SQL command not properly ended
>

You should use WHERE at this point, not AND. Received on Tue Sep 02 2003 - 02:22:59 CDT