Re: update statement

Oops!
Disregard my previous message.

On Thu, Feb 17, 2011 at 3:17 PM, Igor Neyman <igor.neyman@xxxxxxxxx> wrote:

>
> Probably your "FROM" clause should be "annmarie" and not "annmarie.
> s_subject"
> How about:
>
> UPDATE s_subject
>  SET u_mrn = (SELECT u_mrn FROM annmarie
>  WHERE annmarie.s_subject.s_subjectid = s_subject.s_subjectid)
>  where exists
>
>  (SELECT u_mrn FROM annmarie
>  WHERE annmarie.s_subject.s_subjectid = s_subject.s_subjectid);
>
> Regards,
> Igor Neyman
>
> On Thu, Feb 17, 2011 at 3:12 PM, Zelli, Brian <Brian.Zelli@xxxxxxxxxxxxxxx
> > wrote:
>
>>  yes
>>
>>
>>
>>
>> ciao,
>>
>> Brian
>>
>>
>>
>>
>>  ------------------------------
>> *From:* Igor Neyman [mailto:igor.neyman@xxxxxxxxx]
>> *Sent:* Thursday, February 17, 2011 3:13 PM
>> *To:* Zelli, Brian
>> *Cc:* oracle-l-freelists
>> *Subject:* Re: update statement
>>
>> Is s_subjectid - a key in both: s_subject and annmarie tables?
>>
>> Regards,
>> Igor Neyman
>>
>> On Thu, Feb 17, 2011 at 3:06 PM, Zelli, Brian <
>> Brian.Zelli@xxxxxxxxxxxxxxx> wrote:
>>
>>>  SQL> UPDATE s_subject
>>>   2  SET u_mrn = (SELECT u_mrn FROM annmarie.s_subject
>>>   3  WHERE annmarie.s_subject.s_subjectid = s_subject.s_subjectid)
>>>   4  where exists
>>>   5  (SELECT u_mrn FROM annmarie.s_subject
>>>   6  WHERE annmarie.s_subject.s_subjectid = s_subject.s_subjectid);
>>> SET u_mrn = (SELECT u_mrn FROM annmarie.s_subject
>>>              *
>>> ERROR at line 2:
>>> ORA-01427: single-row subquery returns more than one row
>>>
>>> Ok, I am trying to update the mrn data based on the subjectid's being
>>> equal.  It errors saying:
>>> This is a key and there shouldn't be any duplicates.  An example I saw
>>> uses the same code.
>>>
>>> What is wrong with the code?
>>>
>>>
>>>
>>> Brian
>>>
>>>
>>>
>>> This email message may contain legally privileged and/or confidential
>>> information. If you are not the intended recipient(s), or the employee or
>>> agent responsible for the delivery of this message to the intended
>>> recipient(s), you are hereby notified that any disclosure, copying,
>>> distribution, or use of this email message is prohibited. If you have
>>> received this message in error, please notify the sender immediately by
>>> e-mail and delete this email message from your computer. Thank you.
>>
>>
>>
>> This email message may contain legally privileged and/or confidential
>> information. If you are not the intended recipient(s), or the employee or
>> agent responsible for the delivery of this message to the intended
>> recipient(s), you are hereby notified that any disclosure, copying,
>> distribution, or use of this email message is prohibited. If you have
>> received this message in error, please notify the sender immediately by
>> e-mail and delete this email message from your computer. Thank you.
>>
>
>

Other related posts: