When will i finish this book?

I somehow feel these days its very difficult to finish reading a book.When you buy a book , you get so fired up seeing the new book with colorful cover and nice smelling pages.But after 45/50 pages, you just starting to skim over remaining…

Merge is a good technique to updating values quickly . If you want to update values in a big table from a table(with only columns meant for update) , you may write the code like below….

PS -> If you have indexes created on the columns of match , the merge update will be faster.

Now the code is ….

Merge /*+ PARALLEL */ into <schema>.<table> t1 using

(select col1 , col2 from <schema>.<table> ) t2 on t1.<join column > = t2.<join column>

when matched then update set t1.column1 = t2.column1

where t1.xxx = ‘Y’ //optional

Ofcoure the above one is a variant of MERGE , there are many ways …but this is one of the way…

subin alex

I am a software engineer.Onewho gets bored like normal people

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store