How to update multiple fields in Oracle multi-Table Association

The following article describes how to update multiple fields with conditions in Oracle multi-Table Association, if you are a beginner in Oracle multi-table join update with multiple fields with actual conditions, you can use the following articles to better understand how to use the correct method for updating multiple fields in Oracle multi-Table Association. The following is a detailed description of the article.

Oracle multi-table join update multiple fields with conditions

 
 

  
  
update student A  
  
  
set (A.name,a.dq) =  
  
  
(select B.bname,b.bdq  
  
  
from newstudent B  
  
  
where B.Bid = A.id  
  
  
and A.dq = 10 
  
  
)  
  
  
where exists (select 1  
  
  
from newstudent B  
  
  
where B.Bid = A.id  
  
  
and A.dq = 10 
  
  
);  
 
 

 

The above content describes how to update multiple fields with conditions and related patterns in Oracle multi-Table Association. We hope this will help you in this aspect.