Update in oracle using select - dBforums

Update in oracle using select ... UPDATE TABLE1 T1 SET T1.field2 = ( SELECT somefield FROM TABLE2. ... Looks like you might be missing an EXISTS in your WHERE clause.

www.dbforums.com