Oracle Update Syntax

Giganews Newsgroups
Subject: Oracle Update Syntax
Posted by:  BS (minimy…@yahoo.com)
Date: 21 Aug 2006

Group,

What is wrong here with the syntaxt can someone help me?

  1  update po_vendors
  2  set po_vendors.attribute3 = to_char(contractorimport.contractorid)
  3  from contractorimport , po_vendors
  4* where po_vendors.num_1099 = contractorsimport.ssnnumber
SQL> /
from contractorimport , po_vendors
*
ERROR at line 3:
ORA-00933: SQL command not properly ended

Thanks

Replies