Oracle Community Directory
Oracle Community FAQ
My Oracle Support Community (MOSC)
Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
OTN Speaker Bureau
Database Application Development
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
: Feb 13, 2013 8:10 PM by
Help with Update Statement
Feb 13, 2013 8:00 PM
I have a update statement that is not doing the actual update as returning more than one row.
set CLASS =
from test a,DETAIL b
where a."a_Fk"(+) = ('Az'||b.address_detail_pid);
Any advice is appreciated.
This content has been marked as final.
Show 1 reply
Re: Help with Update Statement
Feb 13, 2013 8:10 PM
in response to
Well the obvious is that you need to modify the query to return only one value.
Post some sample data that shows the values before the update, what you expect the sub-query to return and the values after the update.
We can't even try to reproduce your example with the DDL and some sample data.