title: How can i resolve an ORA-01427 error (Single-row subquery returns more than one row)?
body: <p>My query keeps returning an ORA-01427 error and I don't know how to resolve it.</p>
  
  <pre><code>update db1.CENSUS set (notes)
      =
      (
              select notes
              from db2.CENSUS cen
              where  db1.CENSUS.uid = cen.uid
  
      )
  where headcount_ind = 'Y' and capture_FY = '2015'
  </code></pre>