Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Oracle Update Syntax

Oracle Update Syntax

From: BS <minimyme_at_yahoo.com>
Date: 21 Aug 2006 13:08:14 -0700
Message-ID: <1156190894.243746.51160@b28g2000cwb.googlegroups.com> 





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
Received on Mon Aug 21 2006 - 15:08:14 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US