Results 1 to 1 of 1
  1. #1
    Join Date
    Aug 2003
    Location
    Warri, Nigeria
    Posts
    2

    Unanswered: ORA-01427: single-row subquery returns more than one row

    I am trying to updates some rows in a table. I created a temporary table to reflect the update i want .
    I ran this script and i got this error, ORA-01427: single-row subquery returns more than one row:

    update r_femast set fe_key = (select tag from test_tag1_olom)
    where fe_key in ( 'OLOG116-PV1001-1141',
    'OLOG16-PV1003-1141',
    'OLOG14-PV1005-1141',
    'OLOG14-PV1007-1141',
    'OLOG14-PV1008-1141',
    'OLOG18-PV1009-1141',
    'OLOG14-PV1010-1141',
    'OLOG14-PV1011-1141',
    'OLOG16-PV1012-1141',
    'OLOG16-PV1013-1141',
    'OLOG16-PV1014-1141',
    'OLOG14-PV1015-1141',
    'OLOG13-PV1016-1141',
    'OLOG13-PV1017-1141',
    'OLOG16-PV1018-1141',
    'OLOG14-PV1019-1141',
    'OLOG12-PV1020-1141',
    'OLOG12-PV1021-1141',
    'OLOG13-BV1005-1141',
    'OLOG14-FG1001-1141',
    'OLOG13-PL1001-1141',
    'OLOG14-PL1002-1141',
    'OLOG13-FG1002-1141',
    'OLOG12-BV1001-1141',
    'OLOG18-BV1001-1141',
    'OLOG116-PL1007-1141',
    'OLOG12-PL1008-1141',
    'OLOG13-BV1002-1141',
    'OLOG12-PL1009-1141',
    'OLOG13-BV1004-1141',
    'OLOG13-BV1003-1141');
    There is another way i can update this row without creating a temporary table using the WHERE key word to specify the values of the rows?
    Last edited by bashorun; 08-13-03 at 09:31.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •