Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-01427 single-row subquery returns more than one row
yeoen_at_sdu.nl wrote:
> This is my statement :
>
>
> update relpersoonhierarchiek rel
> set rel.soortfunctie =
> (select fun.cat
> from fun_import fun
> where fun.id = rel.id)
> where rel.id =
> (select fun.id
> from fun_import fun
> where fun.id = rel.id)
>
> ORA-01427: single-row subquery returns more than one row
>
What part of the above error message you don't understand?
Regards
/Rauf
Received on Thu May 26 2005 - 05:31:55 CDT