UPDATE SET query Oracle 9i

From: Henk Dekker <hdekker_at_sparxsystems.com.au>
Date: 1 Sep 2003 23:36:57 -0700
Message-ID: <1900676b.0309012236.2970d95d@posting.google.com>

Help required re: Oracle 9i update query...

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

Thanks
Henk Received on Tue Sep 02 2003 - 01:36:57 CDT