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

    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',
    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?

  2. #2
    Join Date
    Jun 2003
    West Palm Beach, FL

    Red face

    Unless table test_tag1_olom has only one row, your problem is with this select:

    (select tag from test_tag1_olom)

    You have to qualify the query to return only ONE row for each row to update.

    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

Posting Permissions

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