Saturday, May 03, 2025

Breaking News
>> Securing and encrypt View State and Cookies values  >> Page has one or more controls that do not correspond with   >> “The Controls collection cannot be modified because the control contains code blocks”  >> How to fix "Validation(): Element 'xxxx' is not supported  >> How to create a new session in ASP.NET programmatically  >> MySQL Database Backup using mysqldump command    

Editors Picks

Wednesday, December 7, 2011

update with join in oracle

1)
UPDATE target_table t SET t_col1 = ( SELECT s_col1 FROM source_table s  WHERE t.target_id = s.source_id );

2)
update
(
   select t_col1,t_col2,t_col3,s_col1,s_col2,s_col3  from   target_table t  ,source_table s   where  t.target_id = s.source_id
)
set t_col1 = s_col1 ,t_col2 = s_col2  ,t_col3 = s_col3;

No comments :

Post a Comment

Contact Us

Name

Email *

Message *