Re: Oracle Update Syntax

From: BS <minimyme_at_yahoo.com>
Date: 21 Aug 2006 13:25:02 -0700
Message-ID: <1156191902.881938.244350@m79g2000cwm.googlegroups.com>

>
> You miss a select, you should have something
> along the line of:
> update po_vendors
> set po_vendors.attribute3 =
> select to_char(contractorimport.contractorid)
> from contractorimport
> where po_vendors.num_1099 = contractorsimport.ssnnumber
>
> --
> Regards,
> Frank van Bortel
>
> Top-posting is one way to shut me up...

Not working...

  1 update po_vendors
  2 set po_vendors.attribute3 = (

  3     select to_char(contractorimport.contractorid)
  4     from contractorimport

  5* where po_vendors.num_1099 = contractorimport.ssnnumber ) SQL> /
   select to_char(contractorimport.contractorid)    *
ERROR at line 3:
ORA-01427: single-row subquery returns more than one row Received on Mon Aug 21 2006 - 15:25:02 CDT