Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL UPDATE

657009Aug 28 2008 — edited Aug 28 2008

Dear All

Below sql is my target query, but it throws some errors:

UPDATE MTP_ROUTING mtpRouting,SPLNKREM spLnkRem,SCCP_ROUTING tempSuaSpenhs ,REF_IP_PROTOCOL refIp
SET mtpRouting.TRAFFIC_TYPE_ID = refIp.ID,
mtpRouitng.SCTP_ASSOCIATION_ID = spLnkRem.SCTP_ASSOCIATION_ID
WHERE tempSuaSpenhs.LISTID = spLnkRem.SPLNKREM_ID
AND mtpRouting. ADJ_DPC = tempSuaSpenhs.DPC
AND mtpRouitng.NE = tempSuaSpenhs.NE
AND mtpRouting.NET_ID = tempSuaSpenhs.NET_ID
AND mtpRouting.TRAFFIC_TYPE_ID IS NULL
AND refIp.IP_PROTOCOL = 'SUA';

Error report:
SQL Error: ORA-00971: missing SET keyword
00971. 00000 - "missing SET keyword"

Plz help to dig out of this error.

Rgds
Prem

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 25 2008

Added on Aug 28 2008

#general-database-discussions, #sql, #update

2 comments

445 views